| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup value if multiple matches are met
Hi all, I have two spreadsheets. Spreadsheet 1 contains an invoice # (A:A) and Part # (B:B). Spreadsheet 2 Contains the same information invoice # (C:C) and Part # (E:E). On Spreadsheet 1,each invoice contains multiple partnumbers. ColA ColB 89853656 FS485AW#ABA 89853656 AH058AA 89853657 RA373AA#ABA 89853694 KD911A4#ABA 89853694 U4414E 89853694 CC532A 89853694 KP080AA#ABA On spreadsheet 2, if my serial number, 89853694, exists on Sheet 1 lookup my part number, U4414E. If my part number, U4414E is found, return U4414E - else return "". Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with multiple matches | Excel Discussion (Misc queries) | |||
| How do I use lookup to return multiple matches and sum them? | Excel Discussion (Misc queries) | |||
| Multiple matches using LOOKUP | Excel Discussion (Misc queries) | |||
| Multiple matches using LOOKUP | Excel Worksheet Functions | |||
| Is it possible to do a vertical lookup that matches on 2 criteria | Excel Worksheet Functions | |||
Threaded Mode
