Lookups

  • Thread starter Thread starter Stephen Calvert
  • Start date Start date
S

Stephen Calvert

Please can any one help, I would like any advice on how
to achieve the following. I believe this is achievable by
use of Lookup.

In column A I have a budget code.
In column B I have the value of the order.

To one side I have a list of Budget Codes, next to which
is the field for running expenditure on that Budget code
so far. I would like to be able to search the column of
Codes and total the value of all orders relating to a
budget code.

This information to be shown next to the Budget code
 
Stephen,

The SUMIF formula should work for you

=SUMIF(A:A,CODE,B:B)
CODE would be your desired code or a cell reference
to the cell containing the code.

Look in help under SUMIF, if you run into problems
post back.

Dan E
 
I have a table in which depending on the calculation will contain a cell with the word "END" in the cell. Lets
suppose that the word ends up in d5 on 1 occassion d10 on another or whatever.
What I want is the lookup to give me what is contained in column A and row in which theword "end" appears .
eg. d3 would contain the sentence. Mortgage ends in the year xxxx. The value xxxx
is in column A. Depending on other calculations the word "END" might be in any cell in column D thus the
ending year of the mortgage would change. I have no problem using vlookup to find the word "END" in column D.
The problem is how do I get the value in column A.

Please help

email: (e-mail address removed)
 
Back
Top