How do I find the Critical Value?

Reg : how do i find a value next nearest value,

• A B C D 360 1528 146 2614 My question, A-360, and i want to bring out that its next nearest value within the four value(A,B,C,D), how do i find the value,(i know that its next nearest value is B-1528, i have more than 10,000 data, i couldn't find) pls tell me how do to find it,

• Answer:

  Hi Raja How are you? Please try the following 1. Type A B C D 360 1528 146 2614 in B8:C11 2. Type B in B14 3. Type in C14 =Vlookup(Chr(Code(B14)+1);$B$8:$C$11;2) I am not sure about the name of the function Code... In Portuguese it is =PROCV(CAR?CT(C?DIGO(B14)+1);$B$8:$C$11;2) Car¨¢ct - returns the character with the ASCII code B14+1 Well I convert B into its ASCII code Sum up 1 Then convert again to Character Adelaide