Matching data on multiple sheets

[LostinVA]

Hi All -

Is there a way to compare data in a column of one workbook tab with data on another tab (multiple columns) to see if there are ANY matches in the string of data??

For example:

Sheet 1, Cell A1: "Red, Yellow, Car, Truck"
Sheet 2, Column A is "Color" and Column B is "Vehicle Type"
- Column A contains the value "Red" in cell A15
- Column B contains the value "Car" in cell B5 and the value "Truck" in cell B10.

So on the first tab, is there a way to identify that "Red", "Car", and "Truck" were a match to data from Sheet 2?

My apologies if this doesn't quite make sense, I'm having a hard time describing my ask.

Appreciate any help you all can provide. Thank you!

 

[JLGWhiz]

I'm no expert, I have made some changes to the code, you can download From this link. I have changed some of Fluffs code, hope it helps.

I have also added comments to the code have a read, if you want to make changes

I do not believe this type of reference conforms to MrExcel posting guidelines. The link provided requires the user to create an account to log in and MrExcel forum members will not have access to the solutions offered. It would be better if you post your suggested solutions in the thread where the members can all see it.

 

[Sharid]

I'm not sure what you see on your end, but when I look at it it has a download button and does not require you to logon or create an account, anyone with the link should be able to download a copy, without logging on.