# Check if correct, result is 1 for Yes and N for NO

1. ## Check if correct, result is 1 for Yes and N for NO

Hi All
I think this is a relatively simple lookup formula but I'm struggling to find something similar.
Attached sample, result to appear in column A, if data in B is found in Column C, then result in A is 1 (that's a number): If result is not found, then result in A is N (that's for no).

2. ## Re: Check if correct, result is 1 for Yes and N for NO

Try this.

=IF(ISERROR(MATCH(B2, \$C\$2:\$C\$14, 0)), "N", 1)

3. ## Re: Check if correct, result is 1 for Yes and N for NO

So simple but so effective, thank you so much for this. That was the one thing I hadn't tried, ISERROR.
Well I'll certainly remember that for sure. Thank you so much.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1