Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup using two table ranges
we need to look up data in two separate columns, A and C. we do not want to
include column B. how would we create our vlookup? we've tried several options including =vlookup(C2,[BILLINGS.XLS]SHADD'!$A$2:$A$1000+$C$2:$C$1000,2,FALSE). I guess you could say we're not sure what we're doing! thanks |
#2
|
|||
|
|||
It would be better if you posted some example
the formula below is assuming that the data in cell C2 is a concatenate of col A and Col c data (an in that order) and the returned value is column B =index(b1:b1000,match(c2,[BILLINGS.XLS]SHADD'!A1:a1000&[BILLINGS.XLS]SHADD'!C1:c1000,0)) Array entered (ctrl+shift+enter) "mlou" wrote in message ... we need to look up data in two separate columns, A and C. we do not want to include column B. how would we create our vlookup? we've tried several options including =vlookup(C2,[BILLINGS.XLS]SHADD'!$A$2:$A$1000+$C$2:$C$1000,2,FALSE). I guess you could say we're not sure what we're doing! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
vlookup and named ranges | Excel Worksheet Functions |