| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup 2 columns of data, perform, match, output results
I have 2 worksheets containing data:
1st Worksheet contains Column N N1:1371 N2:1000 N3:1322 2nd worksheet contains Column A A1:1371 A2:1234 A3:5678 I want to match columns n1 and a1 from the 2 worksheets then provide the output of all the related row data contained in the 1st worksheet. Thanks, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with 2 columns of data to match | Excel Worksheet Functions | |||
| V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
| Match Closest Results from Data Array | Excel Discussion (Misc queries) | |||
| Lookup across 2 or more columns to match a row | Excel Worksheet Functions | |||
| How to Perform Lookup on Alphanumeric Data? | Excel Discussion (Misc queries) | |||
Threaded Mode
