How do to an index match for 2 criterias but also start the search at the bottom of the spreadsheet

[bcurrey]

I'm trying to create a formula that will match criteria in column A & B. Once it finds a match, it will return the text that is in column C.

I also need the formula to start the search at the bottom of the spreadsheet and work its way up.

I've found pieces of what I need online, but can't get everything tied into 1 formula.


Here's the formula that I've come up with: =INDEX(Data!D:D,MAX(MATCH(1,(Data!B:B="CAR")*(Data!C:C="RED"),0)))


Here's a link to my spreadsheet: Formula Spreadsheet Test

 

[ISY]

Hi

=LET(k,FILTER(C2:C6,(A2:A6=F2)*(B2:B6=F3)),INDEX(k,ROWS(k)))

 

[Fluff]

Another option

=TAKE(FILTER(C2:C100,(A2:A100=F2)*(B2:B100=F3),""),-1)

 

[Georgiboy]

How about:

=XLOOKUP(F2&F3,A2:A6&B2:B6,C2:C6,"NA",0,-1)