Searching multiple columns and returning data from single, smaller column

Hello all,

I have been trying to solve this problem for a while with no results. In my search here, I did not find exactly what I was looking for but admit that I may have missed it.

Attached is a sample spreadsheet with data set up in a similar fasion to what my spreadsheet looks like. The data begins in 2007 and goes through April, 2011. I separate out the data by month from a dedicated data spreadsheet. Columns A:G are data entries. H and I are calculations. Columns R and S mimic D and F with the exception that they are neither day not year-specific - that is, whatever value is in HE 1 for AECo is the same value for every day in April and for each year of data.

Columns K and H are two of my attempts - not pretty.

Ideally, I would like to compare D2 and G2 with R2:S7 to return -1, which will then be used to calculate a daily profit from either "net profit long" or "net Profit short."

Thanks,

Chris