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

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

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