Re: Sum Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 9 Jan 2006 18:12:36 -0000

=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" <Shawn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D8B3013-4707-4F39-B19A-A86D3AAB361A@xxxxxxxxxxxxxxxx
> 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

.

Prev by Date: Re: Custom Number Format
Next by Date: Re: Marking Dupes
Previous by thread: Re: Custom Number Format
Next by thread: Re: Toggling between a macro running a "Form" and Excel
Index(es):
- Date
- Thread

Relevant Pages

Re: Obtaining Multiple Results Using Index/Match Functions
... cell to populate the Match criteria, ... INDEX/MATCH formula works perfectly to obtain the first matching ... all matching records, ie all objects that are Green. ...
(microsoft.public.excel.worksheet.functions)
Re: If cell a matches cell b then copy cell d to cell e
... matching the cell from one sheet to another sheet and if they match then take ... Private Sub Worksheet_Change ...
(microsoft.public.excel.programming)
Re: How to find a matching row and Insert Data
... Invoice Number in the textbox, the VBA will try to find a matching ... For Each cell In Range ...
(microsoft.public.excel.programming)
Re: table problem
... but if you click on a cell it actually M/D/Y. ... are the desired output from the data.I want to type the desired part ... places the numeric value in the row with the matching date. ... So it needs to put a zero in the cell. ...
(microsoft.public.excel)
Re: Text Highlight
... You could use .Find to locate all matching cells and then alter the markup. ... > to find and highlight the matching keywords in 3 of the columns. ... > keywords is listed in a seperate workbook in the same Excel file. ... > of a cell. ...
(microsoft.public.excel.programming)