IF/Match

Good afternoon,

I'm having a problem with the below formula. I'm trying to do a formula that will check Invoice numbers on two sheets. If they match it will say yes, and if there is no match it will say no. However I'm getting Invalid Data type when there is a match, and No match if they don't match.

=IF(MATCH(Invoice65, {Exceptions}, 0), "yes", "no")

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Paul Newcome

MATCH outputs a numerical value, so you need to say that if the MATCH is greater than zero (meaning it is found within the range), then "yes", otherwise "no".

=IF(MATCH(Invoice65, {Exceptions}, 0) > 0, "yes", "no")

jamalkhalid79936

I have a weird issue. Should i be using the IF/MATCH to narrow down the selection with a helper column?

On a cross linked sheet, i am running an Index Match to match the Unique column value with another sheet's unique column value and bring in the data. It was working fine, but suddenly it became blank. Then i re-wrote the formula and saved / refreshed, the sheet flashed the results and then again goes blank....

=IFERROR(INDEX({Daily Retrofit Intake Sheet Range 1}, MATCH($[Unique Column]@row, {Daily Retrofit Intake Sheet Range 2}, 0)), "")

The sheet containing the formula

Screen Shot 2020-11-17 at 1.49.40 PM.png

Showing blank results

Screen Shot 2020-11-17 at 1.50.37 PM.png

The sheet that is being referenced and the 15/11/20 Riley record is being fetched. The result should be 3.

Screen Shot 2020-11-17 at 1.51.49 PM.png

Am i exceeding some cell linkage limit? I don't see any error anywhere in the activity log or otherwise.

Regards,

Jamal

Paul Newcome

Try removing the IFERROR part and see what pops up.

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.