Dear all,
First of all, thank you for your help.
I'm dealing with a problem in excel and I don't know how to solve it.
This is my column:
A1: 2/1/2015 B1: 9.12
A2: 2/10/2015 B2: 9.31
A3: 3/2/2015 B3: 0.98
A4: 5/11/2015 B4: 21.1
A5: 8/1/2015 B5: 54.2
A6: 10/29/2015 B6: 43.2
What I need to do is a formula that selects the last value from B column take into account the last value of certain date (A Column).
Example: I need to know the last value of end of february. The value must be 9.31. If I search for the last value below 31/3/2015 the output value should be 0.98.
Can you help me how to do it?
Thank you again in advance,
Bookmarks