Thanks for the feedback for multiple values! I will need this for looking at
multiples! Very handy!

bj wrote:
for two only
in B1 enter
=if(isnumber(match(10525-A1,A:A,0)),10525-A1),"")
copy and paste down
or you could use the match portion in if true to find where it is.

for three, You can set up an NxN table and do something similar
for 4 or more it can get very unwieldy.

I wrote a macro to this one time, and when it didn't solve quickly, I
calculated how long it would take to solve and came up with about a hundred
years of computer time.

Hello,
I am trying to identify two cells within a column that total a specific
[quoted text clipped - 16 lines]

Jennifer

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1