I have a schedule sheet that I want to extract only the lines in which
have "PIP" in the Format column.

I could do it with a filter but that seems pretty messy on line
numbering.

vlookup only seems to extract the first observation.

Any help would be cool.

Thanks

Andrew j