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]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=IF(ISNA(MATCH(A2,$B$3:$B$107,0)),"No match","Match")

 

[davidmyers]

Thanks Fluff,
Worked perfectly.
Profile updated.JJJ

 

[Fluff]

You're welcome & thanks for the feedback

 

[davidmyers]

Hi Fluff, Trying your formula, not working, What am I doing wrong?
Trying to copy the matching value from D to B

 

[Fluff]

In what way isn't that working?

 

[davidmyers]

In what way isn't that working?

Cause B2:B7 should be: "B" "B" "B,Z" "B" "B" "Z"

 

[Fluff]

Why?

 

[davidmyers]

I want to find a match between value in cols A and C and then copy value from col. D to B

 

[Fluff]

Then why didn't you say that originally, rather than asking for something you didn't want?