Search and Display certain text

Hello,

I am a newbie with Excel '13 and am trying to do a type of function to automate some searching. I have two lists on two separate tabs in a worksheet. Each tab has two columns with a code and a box it is associated with. I am trying to run a function that will search one list using the other as a reference to check for mistakes.

For instance
Tab 1
A(code) - B(box) - C(function here)
abc12 - hlx12 - Use A1(abc12) to search Tab2 A:A, found on A3 and returns B3, hlx11 - thus showing a mismatch and discrepancy
abc99 - aex17 - Use A1(abc99) to search Tab2 A:A, not found - return blank or UNKN - to show there is no abc99 in tab2
abc13 - aex14 - Use A1(abc13) to search Tab2 A:A, found on A2 and returns B2, aex14 - showing a good match
abc14 - hub99 - Use A1(abc14) to search Tab2 A:A, found on A1 and returns B1, hub99 - showing a good match

Tab 2
A(code) - B(box)
abc14 - hub99
abc13 - aex14
abc12 - hlx11

Please help so I can do this without manually looking through 1000s of rows!
Thank you,
Jason

Originally Posted by mcmahobt

Assuming both your data sets start in cell A1, try this in cell C1 on your Sheet1:

C1:  =IFERROR(INDEX(Sheet2!B:B,MATCH(Sheet1!A1,Sheet2!A:A,0)),"")

And drag down.

Hope this helps!

Worked like a charm!