View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default Vlookup of specific text, then in consecutive rows

Presumably, B4 in the other sheet contains "relief."

Here's one approach with Excel 2003.

In the other sheet put this in C2:
=IF(ISNUMBER(FIND($B$4,MasterTab!O21)),MAX(C$1:C1) +1,"")
and this in D2:
=IF(ROW()-1MAX(C:C),"",
OFFSET(MasterTab!$O$21,MATCH(ROW()-1,C:C,0)-2,39))
then select C2:D2 and copy down for the length of the list.

Column D should contain the desired list. Column B is a helper column,
and can be hidden.