Using Vlookup where the Lookup Value also uses Vlookup

R

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!
 
S

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
 
D

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
 
P

Pete_UK

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

Pete
 
R

reddy

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

Duke Carey

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

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top