Find 1st Occurrence of Number and Return Value In nth Column

Hi Everyone,

I am trying to use VLOOKUP to find the first occurrence of a number and then return the value in a column in the same row. I keep getting an error message when using the ">" operator. The lookup column is DAYS and the values are calculated from a data set that uses seconds as the time stamp, therefore the DAYS column is reported in fractions of a day.

For example, I want to extract the data point from column Data 3 when the day changes from <1 to >1. I know this should be a simple formula, but cannot get past the error.

I am using the following: =VLOOKUP(>1,A2:D9,4,FALSE) in an attempt to return the value 13.760.

Day Data 1 Data 2 Data 3
0.98 3.365 0.953 13.845
0.98 3.365 0.952 13.8271
0.99 3.365 0.950 13.765
0.99 3.365 0.952 13.817
0.99 3.364 0.950 13.751
1.01 3.365 0.950 13.760
1.02 3.365 0.949 13.717
1.03 3.364 0.948 13.708
1.04 3.364 0.948 13.703


Thanks in advance for your help.

Ed

I would use Index Match
=INDEX($D$2:$D$9, MATCH(1, $A$2:$A$9)+1)
1 represents the largest number under what you are looking for, or the value you need to be greater than.
Questions?

Try this array formula**:

=INDEX(D2:D9,MATCH(TRUE,A2:A9>1,0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

You're welcome. Thanks for the feedback!