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

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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 ....
 
Back
Top