View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_2_] Little Penny[_2_] is offline
external usenet poster
 
Posts: 23
Default search or vlookup help

I'm trying to get excel lookup a value and than search for that value
in a column and then return the value two columns to the right. I know
this sound like vlookup but I want excel to continue looking after it
finds the first instance of my lookup value because there maybe 3 or 4
instance of my lookup value that have different values two columns to
the right. How can I do this and what function should I use if possible.