# VLOOKUP or me?

#### PoohsMate

##### Board Regular
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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Bernard

What's the actual problem?

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
ABCDEFGH
6TransactionDatePTARepActivityDescriptionChequeNoExpenditureIncomeAccountBallance
7Ballancebroughtforward56.75
801/07/05DeborahAutumnFayreBookedcidermaker0002726.000.0030.75
902/07/05HarrietWinterFayreBookedsnowmachine-SuppliedF.O.C.bySnowy0.000.0030.75
1003/07/05TomNewBoilersRaffle-moniesfromParentsevening01/07/0526.0056.75
1104/07/05DeborahPianoTuner-attended02/07/050002858.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

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

I think you want

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

Norie, Fergus, Just Jon

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

Replies
2
Views
201
Replies
8
Views
469
Replies
3
Views
472
Replies
4
Views
356
Replies
2
Views
314

1,202,916
Messages
6,052,539
Members
444,591
Latest member
exceldummy774

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back