Hi Guys,
Please could you help me, i have 2 lists and want to search list 2 to see if there are any partial matches to list 1.
eg.
List 1
ball
light
hoop
List 2
cloud
apple
soccerball
road
trafficlight
ive tried {=SEARCH($A$1:$A$3,B1:B5,1)} as the logic seems correct but i am obviously not on the right track and get 3 #VALUE! and 2 #N/A results
Could you please assist.
Many Thanks!
Clinton
Please could you help me, i have 2 lists and want to search list 2 to see if there are any partial matches to list 1.
eg.
List 1
ball
light
hoop
List 2
cloud
apple
soccerball
road
trafficlight
ive tried {=SEARCH($A$1:$A$3,B1:B5,1)} as the logic seems correct but i am obviously not on the right track and get 3 #VALUE! and 2 #N/A results
Could you please assist.
Many Thanks!
Clinton