IF Index/ Match Return Yes or No

Options

Hello,

I am using the below to return Yes or No as true or false matches. I am looking to Confirm if the Contact listed in [Requestor Contact] is also listed in range {Covered Persons List Range 3}. However, It is returning Yes across the board. My range covered 2 columns both in text. Do I need the range to be formatted the same as the search value column? Any guidance is appreciated, thanks.


Current Formula:

=IF(ISERROR(INDEX({Covered Persons List Range 3}, MATCH([Requestor Contact]@row, {Covered Persons List Range 3}, 0))), "Yes", "No")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!