Excel noob here, hopefully this isn't too confusing.
In column A I have dates and in column B I have numbers (represented as 6.5 or 9.0).
An example of the problem I'm having with VLOOKUP:
In cell B3 I have the number 8.0 and I am trying to use VLOOKUP to look down column B for next number greater than or equal to B3 and return the date from the column to the left.
All functions I've tried inserting to find "next greater than or equal to" haven't worked and VLOOKUP only seems to return the number to the right or below any given cell in the range so I've given up after a couple days and narrowed this problem down to two specific ones:
1) How do search a column for the next number greater than or equal to?
2) How do you return data from the left?
Thank you for your time
Cheers
Bookmarks