VLOOKUP where a cell specifies the table array

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

I want to use vlookup where the table array I'm looking up is actually
specified in a cell.

This is what I want:
=vlookup(A1, B2, 2, false)

where B2 has the value "A10:A20"

What is the syntax or construct for this?

Thanks so much
 
=vlookup(A1, indirect(B2), 2, false)


I want to use vlookup where the table array I'm looking up is actually
specified in a cell.

This is what I want:
=vlookup(A1, B2, 2, false)

where B2 has the value "A10:A20"

What is the syntax or construct for this?

Thanks so much
Click to expand...
 
You must log in or register to reply here.

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

sum vlookup results 5
Finding value using greater than, Vlookup, and nested If 2
Vlookup not working where lookup value contains an apostrophe 2
Average of cells from a table given certain criteria 2
Can't Explain N/A in Vlookup 2
VLookup help, or similar function help, Please! 2
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
VLOOKUP returns #N/A 9

Back
Top