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.
|