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

Question

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".

Answer 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

Answer 2

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

like this picture👆👆

Answer 3

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