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.
 
if the values are in row 2 and dates in row 1, try:

=LOOKUP(1,1/(2:2>=500),1:1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Lookup for this? 2
First row where a cell is zero 1
Formulas to reference range based on data in column 8
Access Running Balance in Access 1
Index-Match, with Like or some other Function 7
Find Last entry for Col in Multi column array using cell from another array. 1
SUMPRODUCT and Dates 2

Back
Top