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.