can VLOOKUP use dynamic named ranges?

G

Guest

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
 
D

Don Guillett

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

Happy Thanksgiving from Texas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top