EXCEL TRICKS

Check if Cell A matches Cell B

=IF(A1=B1,”match”,””)

Check if value in Cell A matches in Column B 

=IF(ISERROR(MATCH(A1,B:B, 0)), “No Match”, “Match”)

epic
Author Details
Contributer and Author Enterprise Communications Engineer Hi Epic

testest test 

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments