Nesting Vlookups

[mflibra]

I am trying to accomplish something like this:

=vlookup(a1,vlookup(a1,Tbl,2,false),3,false)

The inner vlookup is a table of table names!

I'm not having any luck as Excel gives me the #N/A

I basically want to check 2 or even 3 conditions (let's say 2 for now)
and based on those 2 conditions to get a lookup.

Example

customer 001 has an Account called inventory and their code is B170
Customer 001 has an Account called hospitality and their code is B222
customer 002 has an Account called inventory and their code is J5
And there are many such customers, accounts and codes.

I want to be able to check the customer number, and then check the account and based on that information provide the code that goes with that customer number and account. I thought a simple Nested Vlookup would handle it. However, I get the error mentioned above.

Any help in this matter is much appreciated.

[starguy]

I am trying to accomplish something like this:

=vlookup(a1,vlookup(a1,Tbl,2,false),3,false)

The inner vlookup is a table of table names!

I'm not having any luck as Excel gives me the #N/A

I basically want to check 2 or even 3 conditions (let's say 2 for now)
and based on those 2 conditions to get a lookup.

Example

customer 001 has an Account called inventory and their code is B170
Customer 001 has an Account called hospitality and their code is B222
customer 002 has an Account called inventory and their code is J5
And there are many such customers, accounts and codes.

I want to be able to check the customer number, and then check the account and based on that information provide the code that goes with that customer number and account. I thought a simple Nested Vlookup would handle it. However, I get the error mentioned above.

Any help in this matter is much appreciated.

Hi
it is better that you attach here a sample workbook in zip format.