| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up multiple criteria
I want to search sheet 2 for both column a and d in sheet 1, and return column c of sheet 2 sheet 1 a b c d KD083 12 1 SC513-0001-67.81 sheet 2 a b c KD082 SCV219-0001-72 4 KD082 SC092/093HB 1 KD082 IT1414/1714 1 KD082 SC513-0001-67.81 1 KD082 DT1414/1714 1 KD082 SCV220-0001-48 4 KD083 SC513-0001-67.81 1 KD083 T-790-68 1 KD083 IT1415/1715 1 KD083 SC092/093HB 1 KD083 SC511-0001-67.81 1 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
