Search a column for data

[RayD]

Hello Everyone,

I am trying to come up with a formula that will search column "C"
(Volume) for nearest number I type in a cell, e.g. If I type in 160,
the formula will search column "C" (Volume) and come up with 161 and
give me the data that is in column "A" (Level), 00-01-04. The data in
column "A" (Level) is what I am after. Is this possible?


Level Volume
00-00-00 0
00-00-01 13
00-00-02 27
00-00-03 40
00-00-04 54
00-00-05 67
00-00-06 81
00-00-07 94
00-01-00 107
00-01-01 121
00-01-02 134
00-01-03 148
00-01-04 161 <--
00-01-05 174
00-01-06 188
00-01-07 201
00-02-00 215

Thanks

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(A1:A100,MATCH(MIN(ABS(C1:C10-lookup_value)),ABS(C1:C100-lookup_v
alue),0))

 

[RayD]

Frank,

That works like a champ.... THANKS!