Posted to microsoft.public.excel.misc
|
|
can VLOOKUP use dynamic named ranges?
Checkout Bob's reply in:
http://groups.google.com/group/micro...933b95ae6ae4eb
--
Gary's Student
"Dave F" wrote:
I have the following VLOOKUP: =IF(ISBLANK(F5),"",IFERROR(VLOOKUP(F5,'Category
Lookup'!$A$1:$B$40,2,FALSE),"New description to be categorized"))
(I'm using XL 2007, hence the "IFERROR" function.)
Can the lookup range $A1$B$40 be replaced with a dynamic named range?
Perhaps a better question is: is there any situation in which you CANNOT use
a dynamic named range in place of a conventional range?
Dave
--
Brevity is the soul of wit.
|