Ok......

=IF(ROW($1:1)...........

Should be:

=IF(ROWS($1:1)............

That'll take care of the #NUM!'s.

Tip: you don't need to repeat the sheet name in a range reference ---
Assets!$C$2:Assets!$C$300

Just use --- Assets!$C$2:$C$300

Also, --- ROW(Assets!A$2:Assets!A$300)-ROW(Assets!A$2)

You really don't need sheet names for these references. These references
don't actually refer to the ranges you see. They just return the number of
the row reference. For example, ROW(Assets!A$2) = ROW(2).
ROW(Assets!A$2:Assets!A$300) = ROW(2:300). This is a little confusing if you
don't understad how the formula works but you can take my word for it!

So, here's your formula cleaned up:

=IF(ROWS($1:1)<=COUNTIF(Assets!$C$2:$C$300,A$1),IN DEX(Assets!$A$2:$A$300,SMALL(IF(Assets!$C$2:$C$300 =A$1,ROW(A$2:A$300)-ROW(A$2)+1),ROWS($1:1))),"")

Don't forget, when you re-enter the edited formula it MUST be re-entered as
an array using the key combination of CTRL,SHIFT,ENTER.

Biff

"rerhart" wrote in
message ...

Here's my actual/modified formula and I still get #NUM! in the blank
cells.

{=IF(ROW($1:1)<=COUNTIF(Assets!$C$2:Assets!$C$300, A$1),INDEX(Assets!$A$2:Assets!$A$300,SMALL(IF(Asse ts!$C$2:Assets!$C$300=A$1,ROW(Assets!A$2:Assets!A$ 300)-ROW(Assets!A$2)+1),ROWS($1:1))),"")}


--
rerhart
------------------------------------------------------------------------
rerhart's Profile:
http://www.excelforum.com/member.php...fo&userid=8138
View this thread: http://www.excelforum.com/showthread...hreadid=570905