Oh okay, thanks for clarifying. Apology that I was not specific.
For example, on the 1st tab - "Purch_Hist..etc" Row 92, Col.B should yield one of the following results from the 2nd tab- "Item Master Extract..." row 1893, row 1894 or row 1910 in Column B.

Essentially what I am trying to do is see if these items from 1st tab already exist anywhere in our master inventory so I will not have to recreate it.