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

Similar Threads

VLOOKUP duplicate values in table the table array? Help me solve 1
Linked Named Ranges 2
Vlookup Using a Reference as a Table Array 0
using strings in vlookup function calls 5
Vlookup to reference offset 1
Mapping integers to strings 6
How do I insert a dynamic reference of a range inside VLOOKUP? 4
VLOOKUP with a Named Range argument 1

Top