VLookup Returning last cell??
For the closest value, assuming that A2:B8 contains the data, try the
following formula that needs to be confirmed with CONTROL+SHIFT
+ENTER....
=INDEX(B2:B8,MATCH(MIN(ABS(A2:A8-0.290)),ABS(A2:A8-0.290),0))
Hope this helps!
On Nov 1, 2:52 pm, wrote:
I've also noticed:
0.014722 a
0.071111 b
0.134722 c
0.201389 d
0.294722 e
0.337500 f
0.395556 g
if I use the following vlookup it will return NA...why?
=VLOOKUP(0.290,A1:B16,2) will return 'd' and I would like it to
return 'e'...the value closest...is there a way?
|