View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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