lookup first value

[kylefoley76]

I'm trying to get lookup to return the first value it encounters when it scans down the column and finds the right value, because the same value appears several time in that column.

I'm trying this

Lookup( value, lookup_range, result_range )

But it's not returning the first value.

The values are dates and as you go down, they increase in time.

 

[dave3009]

Try INDEX/MATCH combo

=INDEX(result_range, MATCH(value, lookup_range, 0))

 

[AlphaFrog]

Try using VLOOKUP or INDEX - MATCH

 

[kylefoley76]

I can get it to work for a simple data point on one spreadsheet but when I try to get it to work for two different spreadsheets I'm getting #n/a

=INDEX(time!$D$1:$D$1000, MATCH(D4,time!$J$1:$J$1000,0))

I then used a simpler formua

=INDEX(g1:g10, MATCH(d4,J1:J10,0))

And that worked even though there was only one appearence of the value in d4 in the column j

 

[kylefoley76]

Now I got it, I forgot to put the highest number up to 4000 not 1000

 

[AlphaFrog]

-deleted