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