Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Add a MATCHIFS formula

Many power users and lightweight users alike have faced the situation where they need to find a row based on multiple criteria. E.g. find the row where column A = "John" and column B = "Doe". MATCHIF doesn't work on this unless you add a calculated column which concatenates the two, but that bloats and clutters the spreadsheet and increases risk of errors.

SUMIFS and COUNTIFS are wonderful formulas. A simple MATCHIFS formula which works similarly would solve the problem elegantly.

16 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Jeremy Lakey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base