Use INDEX MATCH to check all values in column

[davidmyers]

Hi, I have 2 columns - A3:A2249 this has a complete list of values, and B3:B107 has a list of unique selected values, I want to use INDEX MATCH to find all values in col.A that have a match in col.B and show "match" or "no match" in column C for each value in A3:A2249.
Any help much appreciated

 

[Fluff]

How about

=IFNA(INDEX($D$2:$D$100,MATCH(A2,$C$2:$C$100,0)),"No match")

 

[davidmyers]

This is what I was looking for, sorry I didn't make myself clear - still learning

 

[Fluff]

Try the formula in post#11, although it doesn't help anyone when you keep changing the ranges all the time.

 

[davidmyers]

I changed the order 'cause I understand it makes a difference to vlookup.
This solution works for me.
Thanks for your help

 

[Fluff]

Glad to help & thanks for the feedback.