Try

=SUMPRODUCT(--(B2:B1000=N(INDIRECT(ADDRESS(ROW(),2)))),T2:T1000)


Regards,

Peo Sjoblom


"Brian Williams" <Brian wrote in message
...
=SUMPRODUCT(--(B2:B1000=(INDIRECT(ADDRESS(ROW(),2)))),T2:T1000)
returns #Value!

both
=(INDIRECT(ADDRESS(ROW(),2)))
=(INDIRECT(ADDRESS(2,2)))
alone returns the lookup value from b2:b1000 that i am searching for.


=SUMPRODUCT(--(B2:B1000=(INDIRECT(ADDRESS(2,2)))),T2:T1000)
returns what i need

=SUMPRODUCT(--(B2:B1000=(INDIRECT(ADDRESS(2,2)))),T2:T1000) & " " & ROW()

returns what i need + 2
which is the row im looking to acquire in this example

I need row() or something similar to work because this function will need
to
be on every line between 2 and 1000 with the corrosponding row.

any help is appreciated. thanks in advance.