lookup between a range.

[countryfan_nt]

Hello friends,

I tried using the Vlook function by looking for 52 or 72 or 66. The arrays are Col A & B.


I understand why it is not working col A does not have an excat match, is there anyway around it to make it work?

COL A COL B
52 0 to 28 1
72 29 to 33 2
66 34 to 37 3
38 to 42 4
43 to 50 5
51 to 58 6
59 to 63 7
64 to 68 8
69 to 95 9
96 10

Thank you,
Nawaf

 

[Krishnakumar]

=LOOKUP(F1,{0,28,33,37,42,50,58,63,68,95},{1,2,3,4,5,6,7,8,9,10})

where F1 houses the lookup value.

HTH

 

[countryfan_nt]

Thank you for your speedy rescue !

Truly appreciate it =)

Nawaf