Help with an Index Match Formula - If Error Required?

Hello!

Currently using the below formula to pull data from one sheet to another.

=INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0))

I'm getting a #NO MATCH error for any data not yet on the first sheet, but I would preferably like this to return as 'no'. I wasn't sure if I needed some sort of If Error formula but not sure where to start with this.

Thank you so much for your time.

Find more posts tagged with

Accepted answers

Matt Johnson

Hi @Catwah

Try this one:

=IFERROR(INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0)),"no")

Have a great day!

All comments

Matt Johnson

Hi @Catwah

Try this one:

=IFERROR(INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0)),"no")

Have a great day!

Catwah

https://community.smartsheet.com/discussion/comment/491011#Comment_491011

Thank you so much, Matt! This is perfect.

Happy Friday and have a lovely weekend.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.