Index/Match Multiple Criteria

Try this... I added a missing parentheses, and more importantly, entered it as an ARRAY formula, by pressing Ctrl + Shift + Enter, instead of just Enter when applying the formula to the cell:

Formula:

=INDEX(DATA_DEC!$R:$R,MATCH(1,(Summary!$F$4=DATA_DEC!$B:$B)*(Summary!A7=DATA_DEC!$D:$D),0))

Let me know if it works for you.

- Moo

* I will also note that you are going to get errors because the values in column A on the SUMMARY sheet are not truly numbers. They are actually TEXT, that looks like a number. BUT, the values in column D of the DATA_DEC sheet are actually NUMBERS. So they won't match.

To fix that, change the values in column A on the SUMMARY sheet to actual numbers.

After doing that, you will still get #N/A errors for values in column A that aren't on the DATA_DEC sheet, but those can be hidden by changing the formula to:

Formula:

=IFERROR(INDEX(DATA_DEC!$R:$R,MATCH(1,(Summary!$F$4=DATA_DEC!$B:$B)*(Summary!A7=DATA_DEC!$D:$D),0)),"")

Remember to paste that formula into the formula bar for the cell you want it in, then press Ctrl + Shift + Enter to create the ARRAY formula.

- Moo

Glad to help!

- Moo