VLOOKUP Help
 

Having worked with the VLOOPUP function for many years, I am aware of the
problem of developing a list in which the sequence of numbers are not
sequencial. As an example, a list that starts out 01,02,03,04 and then jumps
to 101,102,103, If I enter the lookup as 102, the function basically stops at
the 04 row. Presently, I am dealing with a list of values starting at 01 and
ending at 99999. While not every number is represented between these two
values, I do have groups use any of the 99999 values. Is there a way of
combining functions/formulas to get around the inherit inability for VLOOKUP
to operated in a non-sequential list? Any help would be appreciated.