View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Morgan Morgan is offline
external usenet poster
 
Posts: 39
Default left vlookup with max

hi there,

i have two columns of data, for example Column P has a description and
Column R has the value, is it possible to find the max value in Col R and
have the corresponding description in Col P displayed in another cell?

there is a one column gap in between, is that going to make a difference?

thank you for your help
--
thanks