INDEX and MATCH with multiple criteria || Excel Tips & Tricks || dptutorials

Outstanding!

Is there a quicker way, e.g. with Xlookup?

Item Coat
Size XL
Price CAN YOU PLEASE WRITE THE ANSWER FOR THIS


ITEM Size Price
Sweater Med 1
Coat XL 2
Shirt Large 3
Suite Med 4

Nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻

YOU SHOULD EXPLAIN .HERE YOU JUST PUT THE FARMULA.

Hi, what does the 1 mean at the beginning of the match?

What is thr purpose of putting 1 in starting of match formula?

Can I get your support regarding to this topic where I'm facing an issue. Looking for your contact or email

Hi, thanks for the video and I have more rows and columns in it but couldn't expect the result as per your tutorial