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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup 2 columns of data, perform, match, output results
What is the output, where does it come from?
-- __________________________________ HTH Bob "John" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup 2 columns of data, perform, match, output results
I want to output the data that is contained in the 1st worksheet. So if a
match exists then copy contents from 1st worksheet to another location. Contents a a1...m1 n1 o1 p1 .... -- Thanks, John "Bob Phillips" wrote: What is the output, where does it come from? -- __________________________________ HTH Bob "John" wrote in message ... 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 |
Reply |
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) |