Hi

I have a problem with looking up the data

sample set

B1B291A4 4
B1B291H4 4
B1B291A5 5
B1B291H5 5
B1B291A7 7
B1B291H7 7
B1B291A9 9
B1B291H9 9
B1B291A12 12
B1B291H12 12
B1B291A14 14
B1B291H14 14
B1B291A16 16
B1B291H16 16
..

lookup value - B1B291A6

I need to get the next available value if the lookup is not matched.

if i use the function = vlookup(A1,A:B,2,1) i am getting 16 rather i need to get 5 as output...

this is creating problem if we have alpha numeric lookup...

Any help would be appreciated in solving this..

Thanks
Shabs