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!