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
=ISNA(MATCH(E3,$A$3:$A$687821,FALSE))
=IF($A$3:$A$687821=E3," ","check")
THANK YOU