I want to find the first instance of a value in single row range B9:F9 and return the date in the top row directly above in B1:F1
For instance in range B9:F9 there are a series of numbers constantly increasing from 35-175.
In cell A11 is the threshold value of 100
Above in the range B1:F1 are a series of dates
I want to find the first cell in B9:F9 that is greater than A11 and return the date in the column directly above in B1:F1
I've attached a sample sheet to illustrate.
Find the date.xlsx
I've tried using MATCH just to find the first instance with the -1 value for "greater than" but it keeps returning #N/A
Thank you in advance for your help!
Graham
Bookmarks