Let's assume that you want your results in Column G, starting at G15,
try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

G15, copied down and across:

=INDEX(A$15:A$51,SMALL(IF(ISNUMBER(MATCH($B$15:$B$ 51,{"SDXS","BNDX","UNVI
","BEER","WAGE","UBEN"},0)),ROW($B$15:$B$51)-ROW($B$15)+1),ROWS(G$15:G15)
))

Hope this helps!

In article ,
emonz wrote:

I am working on a worksheet that has been imported into excel from an
antiquated mainframe and so the resulting excel worksheet carries the headers
and footer from the mainframe. Basically, these header and footer prevent
the worksheet from functioning like a data sheet. I want to filter out the
rows with meaningful data. Each of the rows that contain meaningful data has
a text field of 4 characters in column B.
This is what Ive been working with:
=INDEX(A$15:E$51, SMALL(IF(B$15:B$51 = SDXS or BNDX or UNVI or BEER or WAGE
or UBEN, ROW($1:$37)), ROW(15)))

I dont understand how the second ROW call (ROW(15)) functions. If the data
in column B is on the list (SDXS or BNDX or UNVI or BEER or WAGE or UBEN) I
want to return all the data for that same row.