Vlookup Table Array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ZootRot - 27 Oct 2006 10:11 GMT

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.

Reply to this Message

Niek Otten - 27 Oct 2006 10:35 GMT

What does "not working" mean?

Why not just

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

?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Excel 2003
|
[quoted text clipped - 8 lines]
|
| Thanks.

Reply to this Message

ZootRot - 27 Oct 2006 11:00 GMT

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.

> What does "not working" mean?
>
[quoted text clipped - 18 lines]
> |
> | Thanks.

Reply to this Message

Max - 27 Oct 2006 10:52 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Excel 2003
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

ZootRot - 27 Oct 2006 11:19 GMT

Just the ticket!
Thanks.

> Perhaps with Indirect ..
> =VLOOKUP(K2,INDIRECT(A2&"Base"),3)
[quoted text clipped - 10 lines]
>>
>> Thanks.

Reply to this Message

Max - 27 Oct 2006 11:22 GMT

You're welcome.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Just the ticket!
> Thanks.

Reply to this Message