Match and return multiple results

Hello,

I have an array formula that gives me the results I want but it is slow, and as I need to use it many times (around 60 instances or so), in it's current form it's unusable! can anyone help me refine it?

=INDEX(PerfData!$B:$B, SMALL(IF($B$2=PerfData!$D:$D, ROW(PerfData!$D:$D)-MIN(ROW(PerfData!$D:$D))+1, ""), ROW(A1)))

I am looking up a name from a list box (b:2), finding all matching instances of this name on another worksheet (PerfData, column D:D), and then returning the number listed in the corresponding cell in another column (PerfData, column B:B).

Is there a faster way around this? I'm sure there must be, as this doesn't seem to be a particularly complicated thing that I'm trying to do, but my Excel skills aren't strong enough!

Thanks
J

DonkeyOte:

Thank you for the tip! I reduced down the whole column refs to a range more closely fitting my data and things sped up remarkably.

I'm not sure if this deserves a new thread, but I have a follow on issue now that this is up to a decent sped, which you could perhaps help me with. Once the results are in, I have many other columns populating with Vlookups using the ID number I returned with the original formula. This also works fine, but I am unable to sort my new data by anything but the date returned by the original formula.

For example, one column is a date column. When I sort by this column, for a fraction of a second it rearranges correctly, but then as the formulas get processed, it sorts right back by the ID column.

Thanks again.