| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two column lookup
i'm new to excel & what i'm trying to do is; lookup two cells (A2:B2) in
sheet1 & find the matching data in sheet2 (A2:B20) and return the data in column "D" Sheet 1 answer A B C D 103539 1000800796 2 37500042 103539 1000800797 3 103539 1002055700 4 103539 1000800793 5 103539 1001331388 6 103539 1000926809 7 103539 1002521267 1 103539 1000762584 1 103539 1000762551 2 103539 1000992028 3 103539 1000401463 1 Sheet 2 A B C 103539 1001904703 42500042 103539 1000800796 37500042 103539 1000800797 57500042 103539 1002055700 77500042 103539 1000800793 27500042 103539 1001331388 67500042 103539 1000926809 87500042 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
| LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
| lookup text in one column, count in another column | Excel Worksheet Functions | |||
| Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
| Calculating totals in a column based on a lookup in another column | Excel Worksheet Functions | |||
Threaded Mode
