View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rich
 
Posts: n/a
Default continue VLOOKUP to next value

I'm using VLOOKUP function to search through col A to extract data from
col B within the same row. However, there are multiple data in col A,
which fulfil the condition defined in VLOOKUP. The function finds only
the first cell that fulfills the condition. Is there any way how to
repeat/continue VLOOKUP search for next matching value bellow in col A
and thus place several extracted values from col B to new a column?
Thanks