can VLOOKUP use dynamic named ranges?
 

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.

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.

can VLOOKUP use dynamic named ranges?
 

Why don't you try it before asking?
'Category Lookup'!$A$1:$B$40
instead use
mynamedrange

Happy Thanksgiving from Texas.

--
Don Guillett
SalesAid Software

"Dave F" wrote in message
...
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.