Vector lookup function

G

GregTh

Tried vlookup and reveiwed the others. Setting to false then requires a
exact match. What I need is to find let's say 10 in data of a sinusoida
wave and refernce the time of occurance. I will accept as close to 10 a
possible within the specified time frame. The data within that tim
frame might be ascending or descending. All lookup functions state dat
must be sorted or you can change to false and if not an exact match wil
return #NA
 
L

LanceB

A B C
5 a d
3 b
4 c
11 d
3 e
1 f
16 g
34 h
23 i

Formula for c1
{=INDEX(B1:B9,MATCH(TRUE,ABS(10-A1:A9)=MIN(ABS(10-A1:A9)),0))}

Array Formula ctrl|shift|enter
11 is the closest value to 10 column a, returns the letter d for column b

Lance
 
Top