Find the sum of values in column D that equals the value
in A1
D
A1 10
600 100
500
50
200
Is there a function that does this and can it tell me
which cells in Column D were used to find the Value in A1

Also if multiple if source values are used.

Complicated I know but no other way of explaining.
Currently using a macro to find if cell and cell.offset
(1,0)=A1 etc


Send the answer to as well as
here.

Probably no result, that's okay.