• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 387
  • Last Modified:

In an Excel sheet can I MATCH a cell using more than one lookup value ?

Hi All,

Is it possible to perform a MATCH using more than one lookup value/range ?

For example:

=MATCH(A1,F:F,0) will return the row number if a match is found in column F of the value in A1

What if I want to find the row number when more than one match/column condition exists ?

For example:

=MATCH(A1,F:F,0) and MATCH(B1,G:G,0) must both be TRUE before the row number is returned

Thanks in anticipation
1 Solution
This should work:

Also An array formula should do it:
enter with [ctrl]+[shift]+[enter]

I would specify the range of rows though as with the big excel sheet it may get slow:
enter with [ctrl]+[shift]+[enter]

*note: I use a pipe in my concatenation as it is not good practice to exclude a delimiter
10:1 is the same as 1:01 if you do not use a delimiter.
TocogroupAuthor Commented:
Thanks for that. It worked perfectly.
Much appreciated
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now