Can you nest a CONCATENATE within a VLOOKUP

L

Lance

use the INDIRECT fuction.

eg
=VLOOKUP(D16,INDIRECT(D15&"A1:A9"),1,0)
where d15 = the path and "a1:a9" = the table

LAnce
 
A

Andi

I tried what you had suggested and received a #REF error.
I tried two different ways.

This:
=VLOOKUP(C1,INDIRECT("c:\my
temp\"&A2&".xls"&"A1:B2"),2,FALSE)

and This:
=VLOOKUP(C1,INDIRECT(B2&"A1:B2"),2,FALSE)

I receive the same error both ways.

What am I missing?
 

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