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

--

HTH

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


"Shawn" wrote in message
...
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