How to use a cell value as Table Array in VLOOKUP worksheet function

  • Thread starter Thread starter willydlish
  • Start date Start date
W

willydlish

I need to use VLOOKUP for a spreadsheet I'm running and need to use the
value in a cell as the name of the table array for VLOOKUP.

Is this possible ?
 
With the name in A1:

=VLOOKUP(---,INDIRECT(A1),---,---)

HTH
Jason
Atlanta, GA
 
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

Vlookup with a pick list for tables 1
Array Function to do a Sum of VLookUps that translate a letter gra 3
Vlookup problem 1
Excel Vlookup Help 0
Adding the IF function to a VLOOKUP function. 2
Use array for lookup value, to return array of lookups 4
VLOOKUP 2
vlookup range 4

Back
Top