I've got a spreadsheet that has over 1700 rows of data. The data has columns
for:

Property # (col A)
Production Period (col C)
Status (col F)

There are more columns of data, but for this particular question, they are
irrelevant.

The property numbers are listed many times, as are the Production Period,
Product Type and Status. In Column G, what I need to do, is create a
function that looks in columns A, C, D and F, and applies the following logic:

Let's say that my formula will go into G8.

If any row in the range matches A8 and C8, and the Status for that row says
"Keep", then I want G8's formula to return "Keep" as well.

There will be many rows in which the rows match A8 and C8, but the status
will be blank. However, even if there is one which does match and the status
is Keep, then I need it to return "Keep".

Is this at all possible?