VLOOKUP or me?

[PoohsMate]

In a workbook I have a ballance sheet and a seperate Activities sheet where I am trying to monitor current state of expenditure and income per project.

In the Activities sheet I am trying to use VLOOKUP
e.g.
=IF(ISNA(VLOOKUP($A2,BallanceSheetDraft1!C8:C11,6,FALSE)=TRUE),"No SKU",VLOOKUP($A2,BallanceSheetDraft1!C8:C11,6,FALSE))
(Which might not be the correct Function?).

The steps are:
Look in cell A2 of the Activities worksheet
Go to BallanceSheetDraft1
Where that activity name appears in cells C8 to C11
Total the corresponding figures in column F

Transactions in BallanceSheetDraft1 are entered in date order as they happen.
Multiple Activities are involved (I have just quoted one) all have either an Expenditure or Income per Transaction on the Ballance Sheet.

I would appreciate any help to correct either the formula or my method.

Bernard

 

[Norie]

Bernard

What's the actual problem?

 

[PoohsMate]

Norie

The response to my formula (in C2 of the Activities sheet) = #REF!

However there are expenses entered against the Activity and the names correspond as I am using a validation list in BallanceSheetDraft1.

PTA Statement of account.xls
	A	B	C	D	E	F	G	H
6	TransactionDate	PTARep	Activity	Description	ChequeNo	Expenditure	Income	AccountBallance
7				Ballancebroughtforward				56.75
8	01/07/05	Deborah	AutumnFayre	Bookedcidermaker	00027	26.00	0.00	30.75
9	02/07/05	Harriet	WinterFayre	Bookedsnowmachine-SuppliedF.O.C.bySnowy		0.00	0.00	30.75
10	03/07/05	Tom	NewBoilers	Raffle-moniesfromParentsevening01/07/05			26.00	56.75
11	04/07/05	Deborah	Piano	Tuner-attended02/07/05	00028	58.75		-2.00
BallanceSheetDraft1

Somehow the details have all been "blacked out" but at least this gives the headings which might help me explain my problem?
Bernard

 

[Fergus]

Something like : =SUMIF(BallanceSheetDraft1!$C$8:$C$11,Activities!A2,BallanceSheetDraft1!$F$8:$F$11) in Activities!C2 ???

 

[just_jon]

I think you want

=SUMIF(BallanceSheetDraft1!$C$8:$C$11,$A2,BallanceSheetDraft1!$F$8:$F$11)

 

[PoohsMate]

Norie, Fergus, Just Jon

Thank you for your quick and helpful assistance.
The PTA people who asked for my help will be delighted.

(So the answer was Me! )

Are you no longer not from Peru then Norie?

Kind regards

Bernard