View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
atatari
 
Posts: n/a
Default vlookup-Closest value

Dear Friends,

How can I use Vlookup to give me the closest value greather than or equal to
vlookup value.For example if my lookup value is 5 and I have 4.9 and 5.1,5.2
It chooses 5.1 and give me the corresponding value.

Thank you,