Hi!
I checked out your file but did so with macros disabled. I
don't trust ya!
Just a quick look over, your formula uses uneven ranges
and references:
=INDEX($Z$3:$Z$451,SMALL(IF($Y$2:$Y$451=$A$2,ROW
(A$2:A$451)),ROW(2:2)))
Are you specifically wanting to start with the 2nd value?
Is your formula generated by code?
Change to:
=INDEX($Z$2:$Z$451,SMALL(IF($Y$2:$Y$451=$A$2,ROW
(1:450)),ROW(1:1)))
You don't need code to do this.
Biff
-----Original Message-----
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.
.