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
Bookmarks