If/Then In Excel

cansevin
cansevin used Ask the Experts™
on
I need an If/Then statenment in excel. On Sheet 1, Column B, if the cell matches something in Column D of Sheet 2, I need it to say "Yes". If the cell is not in Column D of Sheet 2, it should say "No"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Try this.

=IF(ISERROR(MATCH(B1, Sheet2!D:D,0)), "No", "Yes")

Author

Commented:
Thanks! Works great.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial