View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] kinsham@comcast.net is offline
external usenet poster
 
Posts: 1
Default Searching UPWARDS for a value?

Could anyone suggest worksheet functions that will allow me to search
UP a column for a given value, starting from a given position in the
column.

The vlookup function always searches down and so always returns the
first match rather than the last. I want to do this without having to
sort the data first.

Thanks