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