Vlookup - using a cell to reference a named array

R

Ronin

I have a file that contains several options for the named table array. In a
menu the user identifies what the criteria is and this drives lookups to
determine the name of the array. I am then using this cell reference in my
vlookup. However it appears the formula will not accept a cell reference for
a named array. Does anyone have another solution?
=VLOOKUP(D9,F5,12,FALSE)

where F5 is a calculated value for the table named table array.
thanks
 

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