I am trying to do the following:

I have a series of columns with dates in first column and values in column 3 and 5.

I want to check if date in first column matches my criteria and then return a value from column 3 but from a row below. I want to do this for column 5 also.

Vlookup does not work because it returns value from the same row.

What are some solutions ?

Suman