Sum Question

[Shawn]

Good day to all. It has been awhile since I have had to post a question.

I need the answer to be in cell E1. I need a formula that will look at the
value in cell B1 and then look for a matching value in column D:D. If it
finds a matching value I need the result to be the value in cell A1 added to
the value to the immediate left of the found cell in column D:D. Thanks in
advance.


--
Thanks
Shawn

[Bob Phillips]

=IF(ISNUMBER(MATCH(B1,D:D,0)),A1+INDEX(C:C,MATCH(B1,D:D,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shawn" <[email protected]> wrote in message
news:[email protected]...
> Good day to all. It has been awhile since I have had to post a question.
>
> I need the answer to be in cell E1. I need a formula that will look at
the
> value in cell B1 and then look for a matching value in column D:D. If it
> finds a matching value I need the result to be the value in cell A1 added
to
> the value to the immediate left of the found cell in column D:D. Thanks
in
> advance.
>
>
> --
> Thanks
> Shawn