Replacing a Table-array with a cell reference in vlookup

A

Allan

I have created a named range. I use the name of the range as the second
argument in the vlookup function and the function works fine.

I would like to replace the name of the range with a cell reference. The
cell being referred to indicates the name of the range. When I do this, the
function ceases to work.

Can this be done?
 
M

Mike H

Allan

Try this

=VLOOKUP(D1,INDIRECT(A1),2,FALSE)

Where A1 contains the name of your named range

Mike
 
M

Max

Try INDIRECT
eg in say, C2:
=VLOOKUP(B2,INDIRECT(A2),2,0)
where A2 contains the named range
 

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

Prompt For Replace in Selection And More... 0
VLOOKUP & Data Validation 0
Linked Named Ranges 2
Using Value of a Cell in the Range Reference in VLOOKUP 1
using a defined Name in a function 2
trouble with (complicated) vlookup searching another workbook 2
WORD VBA Search and switch to advanced ... 1
Vlookup and return sheet name also 2

Top