Yes/No value formula for if text is found in range

**PAIGEBARDEN** · 12-18-2018, 01:28 PM

Hi,

i've been struggling to find a simple or effective formula for the below:

i have a list of names and i want to confirm, (yes or no), if each name is found in a second list of names.

=IF(ISNA(VLOOKUP(A1,RANGE,2,FALSE)),"no",VLOOKUP(A1,RANGE,2,FALSE))

this worked okay however it didn't give me the 'yes' text if it was correct, instead it just copied the name

is there a simpler way? e.g. COUNTIF

thanks!

**Bo_Ry** · 12-18-2018, 01:42 PM

Please try

=if(countif(range,a1),"Yes","No")

**davesexcel** · 12-18-2018, 01:43 PM

Yep Countif would work

Formula:

Please Login or Register  to view this content.

Yes/No value formula for if text is found in range

LinkBack

Thread Tools

Rate This Thread

Display

Yes/No value formula for if text is found in range

Re: help! need a yes/no value formula for if text is found in range.

Re: help! need a yes/no value formula for if text is found in range.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to return cell value if/when certain text is found in a range

Programming to return cell value if/when certain text is found in a range

Search for value in a range and overwrite if found and create new if not found

[SOLVED] How to find text then select RANGE form the text found to lastrow of Column J

Return TRUE if 'part text' found in cell range

[SOLVED] vba overwrite text in string if found in a range using adjacent values ( inside same cell)

Set variable sort range based on found text

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions