Hi, I need to find out if any of the list 2 values exists somewhere in the list 1 cells. Below is an example .. The lists will really be many times bigger so I need a formula! The solution I need is a yes or a no against List 1 cells. Many thanks.
Example:
List 1
A2 = NOPOS Ltd WFD REF 38476FH
A3 = 2015095562 MCARE
A4 = 045456AB NOPOS
etc ..
List 2
A2 = 38476
A3 = 45456
A4 = 468281
List 1 Solution ...
B2 = YES
B3 = NO
B4 = YES
Bookmarks