VLOOKUP - table_array filed.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to use the results of a formulae for the table_array field

I have a spreadsheet with 10 named arrays. Depending on the results of a formula in another cell, I am try to get VLOOKUP to use the appropriate named array to look up infomation

e.g I have 2 tables - Ann and Janet
Cell A1, contains a formula that returns the value of either Ann or Janet. I would like to use the returned value to look up data in the correspondigly named table. If I use VLOOKUP("X",A1,2,0), the result #NA is returned. If I change the formula to VLOOKUP("X",Janet,2,0) or VLOOKUP("X",Ann,2,0), I get the expected reult

Any help would be appreciated.
 
one way:

=VLOOKUP("X",INDIRECT(A1),2, 0)

DaveG said:
Is there a way to use the results of a formulae for the table_array field?

I have a spreadsheet with 10 named arrays. Depending on the results of a
formula in another cell, I am try to get VLOOKUP to use the appropriate named
array to look up infomation.

e.g I have 2 tables - Ann and Janet.
Cell A1, contains a formula that returns the value of either Ann or Janet. I
would like to use the returned value to look up data in the correspondigly
named table. If I use VLOOKUP("X",A1,2,0), the result #NA is returned. If I
change the formula to VLOOKUP("X",Janet,2,0) or VLOOKUP("X",Ann,2,0), I get
the expected reult.

Any help would be appreciated.
Click to expand...
 
Back
Top