Comparison of two columns with data import from a third column

I have searched for a solution to this problem on this and many other forums and have been able to solve it up to a point. Now I'm stuck and in need of help.

I have a workbook containing two sheets and I need to be able to compare the data in column A on both sheets to find matches. Once a match is found it must copy the contents from sheet 2 column B same row to sheet 1 column I. So far this is what I have:

=IF(ISNA(INDEX(QUANTUM!$A:$A,MATCH($A2,QUANTUM!$B:$B,0),1)),"",INDEX(QUANTUM!$B:$B,MATCH($A2,QUANTUM!$A:$A,0),1))

This works, but only if the data match between sheet 1 and sheet 2 column A is on the same row. I need it to search the entire column A on sheet 2 for matches.

Please let me know if I am going about this the wrong way. Thanks in advance for any help.

DANMAC80,

Attached is a modified version of your sample workbook. In Sheet1, cell I2, is the following formula:
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

Then I copied down.

Hope that helps,
~tigeravatar

That appears to have worked. Thank you very much for your help.