Search Database (multiple criteria)

Question

I am having difficulty with the following, maybe you can help.

I need a formula to search for the following details. I need him to do the following:

• Column 2 search for "A"
• Filter available rows by column criterion 3 with a value of "B1"
• Filter Available Rows by Latest Date from Column A
• Returns the value from column D

  DATE A A1 VALUE 1
 DATE C D1 VALUE 1
 DATE B F1 VALUE 1
 DATE A A1 VALUE 1
 DATE C P1 VALUE 1

Thanks Phil

Answer 1

You can try this formula:

=INDEX(D1:D6,MATCH(9^99,IF(IF((B1:B6="A")*(C1:C6="B1"),A1:A6)=MAX(IF((B1:B6="A")*(C1:C6="B1"),A1:A6)),ROW(D1:D6)))) 

This is an array formula, so you will need to use Ctrl + Shift + Enter to make it work as intended.