Last answered:

24 Dec 2023

Posted on:

14 Dec 2023

1

Resolved: How do I use "index match match" when I have several arrays?

Hello, Mr. Ned

How do I use "index match match" when I have several arrays like Vlookup? because "index match match" is superior to "Vlookup".

3 answers ( 1 marked as helpful)
Instructor
Posted on:

15 Dec 2023

1

Hey Daniel,

Good to hear from you. Here's an illustration when I'd use VLOOKUP/INDEX&MATCH:

And here's when I'd use INDEX, MATCH, MATCH:

Does this make sense?

Best,

Ned

Posted on:

24 Dec 2023

0

Hello Mr. Ned, thank you for your reply. I mean, How to use index match match between several tables?

like this picture👆👆

Posted on:

24 Dec 2023

0

Hello Mr. Ned, thank you for your reply. I mean, How to use index match match between several tables?

like this picture👆👆

Submit an answer