Hi All,
I have some suppliers that i am getting regular price sheets from, i am looking to either search using =VLOOKUP command but i want to find out how to search Similar Terms, for example:
A2 Samsung 840 SSD 500GB
F2 Samsung 840 EVO MZ-7TE500BW 2.5" 500GB

More Detail:

\1

What i am trying to achieve is to get the "Products" from Supplier A to see if they match with Supplier B,
for example i see that Supplier A has "UNITEK BF-8223Y Mini Bluetooth USB Adapter (Class 2)Version 2.1+EDR Data Rate up to 3 Mbps. Operational Range 20M" (3/4 the way down) now i want to check that Supplier B doesn't have the same, however the strings are not exactly the same. they may contain parts of the above, for example "UNITEK BF-8223Y Mini Bluetooth USB Adapter" might be all that is shown, VLOOKUP doesnt find this as it needs to be an exact match.

if anyone can help me find a way i would be grateful, or another way to compare 2-4 spreadsheets with similar data.