Nigel Martin
Board Regular
- Joined
- Feb 17, 2002
- Messages
- 133
What is wrong with this? =OFFSET(Utilities!$M$1,0,0,MATCH(REPT("z",255),Utilities!$M:$M)) which is a named range called Discount. When I try to validate a cell using the List>Custom option =Discount I get an error message that reads "The source currently evaluates to an error". Where column M in worksheet Utilities containes the list. Any ideas?