Lookup Based On Multiple Tables

[Maroota]

Hi All

I am hoping someone could help me with a query.

I am trying to produce a formula that would lookup an item based on a specific table (mutiple).

Table Names Red, Blue, Green for example (ODBC table)

Cell A1 - "Red"
Cell A2 - 10000

I need a formula to lookup Cell A2 within the table named "Red" and in A3 the result of the 3rd column along.

If A1 is changed to "blue" then the lookup is from the table named "blue"

Thanks very much for your time

Diane

[windy58]

Diane

Try this:
=IF(A1="Red",VLOOKUP(A2,Red,2,FALSE),IF(A1="Blue",VLOOKUP(A2,Blue,2,FALSE),IF(A1="Green",VLOOKUP(A2,Green,2,FALSE),0)))

The Red, Green & Blue without the quotes are named ranges representing your three tables.

Windy

[azumi]

I hope with example make it clear

Azumi

[Maroota]

Thanks Windy58 and Azumi.

Your help is very much appreciated.

Everything works a dream. It is such a useful tool to have, and am sure I will be using it again in the future.

Once again many thanks for your time.

Diane