Index Matching multiple variables (SELECT date FROM table WHERE serial = x AND step = y)

[ripcurlksm]

I am trying to do an index match where I can filter out the data by 2 variables instead of one. Since each serial number has multiple entries, I want to do something like this for anyone that knows MySQL SELECT date FROM table WHERE serial = x AND step = y

With one MATCH function it just repeats the first date. So I tried adding 2 MATCH() functions but it breaks:
Capture.JPG

I've also attached an excel file (see attached). Any ideas?

[AliGW]

Welcome to the forum.

INDEX MATCH MATCH won't work because the lookup values are both in columns. Try this instead:

=IFNA(LOOKUP(2,1/(($A:$A=$F3)*($B:$B=G$2)),$C:$C),"")

[ripcurlksm]

Wow that worked perfectly! Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.