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