| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Vlookup where the Lookup Value also uses Vlookup
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
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 "reddy" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
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 "reddy" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
Post both formulae that you are using, together with a more detailed
description of the tables you are using. Pete On Aug 15, 6:33*pm, reddy wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
Both the columns reference the same table to obtain the values. The table
contains unique values for Lender No, Lender Name & Product. "reddy" wrote: 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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
Then duplicate the first VLOOKUP formula but change the 3rd argument to
reference the column that contains the product info "reddy" wrote: Both the columns reference the same table to obtain the values. The table contains unique values for Lender No, Lender Name & Product. "reddy" wrote: 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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup where the Lookup Value also uses Vlookup
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!!! "Duke Carey" wrote: Then duplicate the first VLOOKUP formula but change the 3rd argument to reference the column that contains the product info "reddy" wrote: Both the columns reference the same table to obtain the values. The table contains unique values for Lender No, Lender Name & Product. "reddy" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup or vlookup | Excel Worksheet Functions | |||
| Help with lookup (vlookup) | Excel Worksheet Functions | |||
| Help with Lookup(), VLookup | Excel Worksheet Functions | |||
| Lookup without VLOOKUP? | New Users to Excel | |||
| LOOKUP or VLOOKUP | Excel Worksheet Functions | |||
Linear Mode
