# XLOOKUP vs INDEX & MATCH?

1. ## XLOOKUP vs INDEX & MATCH?

Hi,

In the attached workbook I have sample data in A:E.

In cell K6 I have an INDEX MATCH formula that extracts the value that corresponds with the conditions in H3:H6.

Is it possible to use XLOOKUP() rather than INDEX MATCH to perform such a two-way lookup with multiple conditions?

Thanks!

2. ## Re: XLOOKUP vs INDEX & MATCH?

Try this:

=XLOOKUP(\$I\$5&\$I\$6,\$C\$1:\$E\$1&\$C\$2:\$E\$2,XLOOKUP(\$I\$3&\$I\$4,\$A\$3:\$A\$6&\$B\$3:\$B\$6,\$C\$3:\$E\$6,,0))

https://exceljet.net/formula/xlookup...ay-exact-match

3. ## Re: XLOOKUP vs INDEX & MATCH?

I'd tend to use Filter rather than xlookup
Formula:
`Please Login or Register  to view this content.`

4. ## Re: XLOOKUP vs INDEX & MATCH?

Thanks very much, Ali!

I tried to add to your reputation but can't as I've just done so in my other post that you kindly answered.

5. ## Re: XLOOKUP vs INDEX & MATCH?

Don't worry!

I'd agree with Fluff, by the way, although doing the XLOOKUP was a good academic exercise.

6. ## Re: XLOOKUP vs INDEX & MATCH?

Thank you both very much!

Am I correct to understand that you're suggesting that FILTER() would be preferable to functions like XLOOKUP (and so VLOOKUP) and INDEX MATCH for performing lookups?

7. ## Re: XLOOKUP vs INDEX & MATCH?

In this case, yes, but not necessarily always!

8. ## Re: XLOOKUP vs INDEX & MATCH?

Glad to help & thanks for the feedback.

Normally I would use Xlookup, but in cases like this I just find Filter is easier to understand.

9. ## Re: XLOOKUP vs INDEX & MATCH?

Thanks again!

10. ## Re: XLOOKUP vs INDEX & MATCH?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1