With these parameters...
On sheet "RS"
A2:A986 contains numeric values
(Each of those numbers will exist on sheet "RD")

On sheet "RD"
D2:D15000 contains numeric values
(Some of those values MAY NOT exist in Col_A of sheet "RS")

A2:A15000 contains names associated with the Col_D numbers
(There may be more than one name in Col_A associated with each number in
Col_D)

Col_A/Col_D combinations are unique

------------------------
Try this
On sheet "RS"
B1:K1 contains the series 1,2,....10

This formula returns the Row_1 referenced name associated with the value in
Col_A
B2:
=IF(COUNTIF(RD!$D$2:$D$61,$A2)=B$1,INDEX(RD!$A$1: $A$61,SMALL(INDEX((RD!$D$2:$D$61=RS!$A2)*ROW(RD!$D $2:$D$61)+(RD!$D$2:$D$61<RS!$A2)*10^99,0),RS!B$1) ),"")

Copy that formula down and to the right as far as you need.

Note: In case text wrap impacts the display, that formula contains NO spaces.

Sample returned values (using bogus test data)
Nums 1 2 3
1 a t am
2 b u an
3 c v ao

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"DJ" wrote:

In one worksheet (RS), I have a list of numbers (A2:A:986). What I want to do
is search another sheet (RD) for every name (A2:A15000) that is associated
with each number (D2:D15000) and have it returned to the original sheet (RS)
on the same row as the number, but with each name occupying it's own cell
(B2, C2, D2, etc...)

I've been looking around to see if I can find a similar question and come up
with my own formula, but haven't been able to figure it out yet. It kind of
looks like I'd need to use INDEX, but I haven't used that one before and I'm
stuck.

Hopefully, I explained that adequately. Thanks in advance.