• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Excel Lookup (email in one tab)

I have a workbook with two tabs (SFDC & group)

in tab SFDC I would like column E to be "Y" if the email in SFDC column D exists anywhere in group column E and if it does not exist SFDC column E should be "N"
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=IF(ISERROR(MATCH(D1,group!E:E,0)),"N","Y")

Open in new window

Regards
0
 
Naresh PatelTraderCommented:
Try this
=IFERROR(IF(MATCH(D2,Group!E:E,0)>0,"Y",""),"")

Open in new window



Thanks
0
 
SteveCommented:
This should be better removing need for error handling:

=IF(COUNTIF(Group!E:E,D2)=0,"N","Y")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now