| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Question
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum Question
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
