Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lorry Lorry is offline
external usenet poster
 
Posts: 1
Default Vlookup

I am using the vlookup function and need it to return the match for the next
highest value, not the closest below the value. Example: Value is 61 and I
need it to return the information in column two below (.87) but it's
returning .8, because 59 is below 61. I need it to move to the next up, 64.
Can someone help?

54 .59
59 .8
64 .87