Vector lookup function
 

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


--
GregTh
------------------------------------------------------------------------
GregTh's Profile: http://www.excelforum.com/member.php...o&userid=16085
View this thread: http://www.excelforum.com/showthread...hreadid=275365

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

"GregTh" wrote:


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


--
GregTh
------------------------------------------------------------------------
GregTh's Profile: http://www.excelforum.com/member.php...o&userid=16085
View this thread: http://www.excelforum.com/showthread...hreadid=275365