existing unique value formula help (index(match(countif)))

hmm... not working for me, just gives me an error message on the "0" in
the if statement.

You must have copied some extra characters or done somthing else
incorrectly, it shouldn't stop on that part. The formula works fine


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



<[email protected]> wrote in message
news:[email protected]...
> hmm... not working for me, just gives me an error message on the "0" in
> the if statement.
>

okay i'm not getting an error message anymore, but it's not bringing up
the right information. the formula is bringing up values from "d" with
zeros in "e"; it misses values from d with positive values in "e" and
finally, when you delete one from the top of the list, the rest of the
cloumn should adjust, but it isn't... any clues? if not it's okay, it's
not that much manual work, the original formula is a big help for me
though. thanks again.
jason

It's likely that the numbers in Column E are being recognized as text.
Try the following...

1) Select an empty cell

2) Edit > Copy

3) Select Column E

4) Edit > Paste Special > Add > Ok

Does this help?

In article <[email protected]>,
[email protected] wrote:

> okay i'm not getting an error message anymore, but it's not bringing up
> the right information. the formula is bringing up values from "d" with
> zeros in "e"; it misses values from d with positive values in "e" and
> finally, when you delete one from the top of the list, the rest of the
> cloumn should adjust, but it isn't... any clues? if not it's okay, it's
> not that much manual work, the original formula is a big help for me
> though. thanks again.
> jason