Hi All,

I am new to the forum and have don't know if this is even possible.

I have a spreadsheet that I need to look up values based on a certain criteria.


Location| Name |Status |Paid
CA | Tom |Close |YES
CA | Jerry |Open |NO
AZ | Will |Close |YES
AZ | Sam |Open |NO
NY | Frank |Close |NO
NY | Lisa |Open |NO
WA | Amy |Close |YES
WA | John |Open |NO


Result should be this if I lookup the location for only open orders and return the paid column.


Lookup |Paid
CA |NO
AZ |NO
NY |NO
WA |NO

sorry not sure the best way to paste excel tables.

I have tried other examples on this forum in which I find too difficult to adapt to my situation.

filter-array-example.xlsx