Formula Works Only Sometimes???

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.
>.
>
.

Quantcast