Match or if return value problem

[Invexskm]

HAVE 6 COLUMNS OF DATA, WANT TO MATCH COLUMNS 1 AND 4, 2, AND 5 AND 3 AND 6. WOULD LIKE TO RETURN A BLANK VALUE TO COLUMN H IF TRUE AND "CHECK" IF FALSE. HAVING TROUBLE GETTING IT TO EITHER CHECK AGAINST ENTIRE COLUMN OR RETURN DESIRED VALUE.


=ISNA(MATCH(E3,$A$3:$A$687821,FALSE))
=IF($A$3:$A$687821=E3," ","check")

THANK YOU

 

[Aladin Akyurek]

HAVE 6 COLUMNS OF DATA, WANT TO MATCH COLUMNS 1 AND 4, 2, AND 5 AND 3 AND 6. WOULD LIKE TO RETURN A BLANK VALUE TO COLUMN H IF TRUE AND "CHECK" IF FALSE. HAVING TROUBLE GETTING IT TO EITHER CHECK AGAINST ENTIRE COLUMN OR RETURN DESIRED VALUE.


=ISNA(MATCH(E3,$A$3:$A$687821,FALSE))
=IF($A$3:$A$687821=E3," ","check")

THANK YOU

=ISNUMBER(MATCH(E3,$A$3:$A$687821,0))+0

would yield 1 for a hit, 0 otherwise. What do you have in E3?

 

[schielrn]

Are you wanting to match them all in one formula? If so, maybe:

=if(isna(MATCH(E3,$A$3:$A$687821,FALSE)+MATCH(F3,$B$3:$B$687821,FALSE)+MATCH(G3,$C$3:$C$687821,FALSE)),"Check","")

This would check that all of them had a match or maybe if you only need one of them to have a match try:

=if(or(isnumber(MATCH(E3,$A$3:$A$687821,FALSE)),isnumber(MATCH(F3,$B$3:$B$687821,FALSE)),isnumber(MATCH(G3,$C$3:$C$687821,FALSE)),"","Check")

Also I am not positive if I have the blank and check in the correct spots as I don't completely follow your post.

Hope that helps.