Thread: Vlookup to return larger value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhm yhm is offline
external usenet poster
  
Posts: 2
Default Vlookup to return larger value
Hi,

I have a list of values as follows:
X Y
50 2
80 4
100 6

When I lookup the value of x=85, I would like the returned value to be 6
instead of 4. How do I do that?
Reply With QuoteReply With Quote