I understand. Probably a good practice. The macro isn't important to my
problem anyways. It just takes distinct projects out of the list and returns
it to a cell.

"Gary Brown" wrote:

Sorry Nick,
But we NEVER download mystery files.
Sincerely,
Gary Brown

"Nick" wrote:

I have a formula that works sometimes, but not others.

My example file can be found at www.nmberger.com/example.xls.

After you click the button (make sure cell A2 is highlighted before you
click the button or the formula won't work at all), you select a project from
the list box. Then the all values associated with that project should appear
in the next column over. It works with a lot of the projects, but not all.
Select 4008 or A1GQ, for instance, and you will get values in return. Select
F3MA, 6008, or 1020 and you get nothing. But if you scroll over to columns Y
and Z, you will see that there is values associated with those projects.

Any ideas???

Thanks in advance.