Returning Text Value based on multiple criteria

[Tiiatcha]

Hello,

I am trying to return the text value of a cell depending on if 2 other criterea are true.
Using the example data below I would like to display the status of 'Code'-10.1 from 'Month'-Jan.

Example data Sheet1: (Assume Column Headers are A1, B1, C1)

Code Month Status
10.3 Jan Checked
10.1 Jan complete
11.1 Jan Complete
10.3 Feb Not Checked
10.1 Feb Not Checked

 

[Colin Legg]

This formula needs to be completed with CTRL+SHIFT+ENTER, not just Enter:

=INDEX(C2:C10,MATCH(1,(A2:A10=10.1)*(B2:B10="Jan"),0))

Adjust ranges to suit. The criteria 10.1 and Jan could be kept in individual cells.

HTH
Colin

 

[Tiiatcha]

THank you. That was spot on. Adjusted slightly to meet my needs.

{=IF(ISERROR(INDEX(nrStatus,MATCH(1,(nrSNAT=$A6)*(nrMonth=J$1),0))),"",INDEX(nrStatus,MATCH(1,(nrSNAT=$A6)*(nrMonth=J$1),0)))}