I need help with finding a match in a list.
I have a spreadsheet that has 50k rows of data. In one of the columns there is a list of comma delimited numbers. i.e.
A1: words B1: 1,2,4,34,37,2343
B2: words B2: 3,22,564,223,2344
on a seperate sheet I have these the numbers that column B would be referencing in a list with additional details. i.e.
A1: 1 B1: detail1 C1: detail2
A2: 2 B2: detail1 C2: detail2
What I need to do is add a column to the first sheet showing if any of the numbers in Column B match with any of the numbers in the second sheet. i.e.
Do 1, 2, 4, 34, 37, or 2343 appear in the column A of the second sheet?
I have already created a sheet that has the comma delimited numbers expanded by "text to columns" in an attempt to create an array to use, but I'm not sure if that is going to make it easier or not.
Bookmarks