Thread: use vlookup or other to find the nearest values (<) or interpola
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scoops
 
Posts: n/a
Default use vlookup or other to find the nearest values (<) or interpola
Hi Rodney

Use the Range_lookup value TRUE to return the highest figure lower than
your Lookup_value i.e.

if A1 = 1, A2 = 2, A3 = 4 then

=VLOOKUP(3,A1:A3,1,TRUE) will return "2" where 3 is not found and 2 is
the highest number not exceeding 3

Regards

Steve

Reply With QuoteReply With Quote