Using Vlookup where the Lookup Value also uses Vlookup

[reddy]

I have a table where 2 columns need to be populated with VLookup.
The column Lender Name references a table for its value using the Lender No
as a Lookup Value.
The Column Product references a table for its value using the Lender Name as
a Lookup Value. This causes an error to occur as a the Lender Name column
also uses VLookup.

Lender No. Lender Name Product
123 Citigroup Auto
123 CitiGroup Auto
456 ANZ Mortgage
456 ANZ Mortgage
789 Deutch Lease
789 Deutch Lease

Please help!

 

[Storm]

Hi Reddy.

It should not really matter. I've done it many times where I've used the
vlookup formula and used as my look up value a value resulting from another
vlookup formula. There is something else driving the error.

Storm

 

[Duke Carey]

The most likely culprit is that the lender names returned by the first lookup
are not EXACTLY the same as the lender names in the second table

 

[Pete_UK]

Post both formulae that you are using, together with a more detailed
description of the tables you are using.

Pete

 

[reddy]

Both the columns reference the same table to obtain the values. The table
contains unique values for Lender No, Lender Name & Product.

 

[Duke Carey]

Then duplicate the first VLOOKUP formula but change the 3rd argument to
reference the column that contains the product info

 

[reddy]

As you said, I duplicated the first VLOOKUP formula but change the 3rd
argument to reference the column that contains the product info. It WORKED!
Thank you!!!