Thanks:  0
Likes:  0

# Thread: If Value X exists, say yes or no

1. ## If Value X exists, say yes or no

Hi guys,
I need to create a method of going down column b, and looking at the value in column A, and seeing if it exists in a table I have on another sheet. If Value A exists, then I want ColB to say yes or no.

It seems like it should be so simple, but its killing me!

2. ## Re: If Value X exists, say yes or no

what column is the table on the second sheet in

3. ## Re: If Value X exists, say yes or no

5, or E
starting in row 2

4. ## Re: If Value X exists, say yes or no

Code:
`=IF(ISNA(MATCH(A1,\$F\$1:\$F\$100,0)),"No","Yes")`
fill down

you will need to change the F1:F100 reference to your new sheet

5. ## Re: If Value X exists, say yes or no

Thank you Diddi,
You da man!
I was trying so many combinations of match, find, index, vlookup... i was just in circles...

6. ## Re: If Value X exists, say yes or no

so did it rain yesterday

7. ## Re: If Value X exists, say yes or no

Apparently, but I don't go out much...

8. ## Re: If Value X exists, say yes or no

ooh thats a bit geeky

9. ## Re: If Value X exists, say yes or no

Originally Posted by diddi
Code:
`=IF(ISNA(MATCH(A1,\$F\$1:\$F\$100,0)),"No","Yes")`
fill down

you will need to change the F1:F100 reference to your new sheet
Bumping an old post because this worked for me.

I edited the result to =IF(ISNA(MATCH(E2,E:E,0)),"Not Found","Value found on row " & MATCH(E2,E:E,0)) to match my range

I then added traditional CF (I'm using Excel 2003) to E:E column with FormulaIs =E3=E4 and chose a light yellow for the cell colour; which highlights any duplicates of the above rows.

Many thanks, your gift keeps on giving...

## User Tag List

#### Posting Permissions

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