Vlookup Table Array

[ZootRot]

Excel 2003

I'm Using Vlookup to find data from named table arrays. The looked-up table
array name changed depending on the value in a cell (eg a2) and the column
header (eg Base). I'm trying to create the name of the table array by
joining two strings, but this is not working for me:

eg: =VLOOKUP(k2,text(a2,)&"Base",3)

I can't figure the error in this formula. Any advice?

Thanks.

 

[Niek Otten]

What does "not working" mean?

Why not just

=VLOOKUP(k2,a2&"Base",3)

?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Excel 2003
|
| I'm Using Vlookup to find data from named table arrays. The looked-up table
| array name changed depending on the value in a cell (eg a2) and the column
| header (eg Base). I'm trying to create the name of the table array by
| joining two strings, but this is not working for me:
|
| eg: =VLOOKUP(k2,text(a2,)&"Base",3)
|
| I can't figure the error in this formula. Any advice?
|
| Thanks.
|
|

 

[Max]

Perhaps with Indirect ..
=VLOOKUP(K2,INDIRECT(A2&"Base"),3)

 

[ZootRot]

The error I get is a #VALUE. Using the context menu, the Calculation Steps
show that the "calculated" array name is correct, but still gives an error.
If I type the array name into the formula, it works fine.

 

[ZootRot]

Just the ticket!
Thanks.

Perhaps with Indirect ..
=VLOOKUP(K2,INDIRECT(A2&"Base"),3)

 

[Max]

You're welcome.