CODEWITHSUNDEEP
excelindexingmatch
P.Schmid
P.Schmid

Reputation: 21

Index Match function with multiple criteria Excel

I tried to copy&paste data from one table to another and found the index match excel function very helpful. So one criteria is a number and the other is the date. I found a very good article about the function with multiple criteria but it doesn't work and i cant understand why. https://www.deskbright.com/excel/index-match-multiple-criteria/

I attached the file where i tried my luck. Maybe you can help me find my mistake. https://ufile.io/3kau7

Upvotes: 0

Views: 766

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

No array formula needed:

=INDEX($A:$C,MATCH($A11,$A:$A,0),MATCH(B$10,1:1,0))

enter image description here

Upvotes: 2

Related Questions