How to use > or < in LOOKUP formula?

  • Thread starter Thread starter CC
  • Start date Start date
C

CC

I am trying to search a row of numbers for the first occurence of a number
=500 and return the date at which the number is found, where the dates are
Click to expand...
the column headings in the spreadsheet. I can use LOOKUP to find the date
where the value = 500 but I need to find when it becomes >=500.
 
Back
Top