Lookup 2 columns of data, perform, match, output results

[John]

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

 

[Bob Phillips]

What is the output, where does it come from?

 

[John]

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 are:
a1...m1 n1 o1 p1 ....