View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lacty Lacty is offline
external usenet poster
 
Posts: 14
Default Vlookup, next value


Alex

You might want to create a "helper" cell. If say your value 2.5 is in
cell A1, in B1 enter the formula = Round(A1, 0 )

The Round function will round 2.5 to 3 and 2.4 to 2. Otherwise use the
Roundup function which will round any number from 2..01 and 2.99 to 3

then Use the value in B1 in your Vlookup formula


Hope this helps