Hello community,
Can someone let me know how to write formula that will allow me to add tick in the cell in column E when there is a email in column F that matches an email in column C
For example the email [email protected](F4) matches the email in (C6), therefore there is a tick in E6.And if there is no match then put an X in the column.
Can someone help with formula that will do that automatically?
Cheers
Carlton
Hi Carlton,
Try this:
=IFERROR(IF(MATCH(F2,$C$2:$C$7,0),"P"),"O")
Set the font to Wingdings 2
Regards,
Khalid
Or even simpler:
=IF(COUNTIF($C$2:$C$7,F2),"P","O")
Hi Khal
Thanks for responding.
It doesn't seem to work. see attachment
Khal take a look at [email protected]. There isn't a duplicate for that email
Hi,
See the attached.
No, the formula is searching in column C.Originally Posted by carlton7372
If you want it to search in Column F with criteria of column c, just reverse the formula:
=IF(COUNTIF($F$2:$F$7,C2),"P","O")
Thats great.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks