Help with Vlookup formula

[pedro-egoli]

Still unsure of all the terminology that goes with using this formula and would appreciate assistance.
In the following sheet I want to record any entries paid by Visa in cells H15:H90 and any paid in Cash in Cells I15:I90.
Method of payment is recorded in column B and the amount paid is in columns C:F
You will note I ran into trouble starting with cell H15

I assume VLOOKUP is the formula to use to solve this calculation.

Budget actuals trip itinerary etc.xls
	A	B	C	D	E	F	G	H	I
14	BUDGETREMAINING		$3,530	$2,553	$6,250	$1,950	$14,283	Visa	Cash
15	20/02/09	visa	-$204	-$35				#REF!
16	21/03/09	visa	-$61	-$30
17	15/03/09	visa	-$204	-$42
18	23/03/09	visa				-$150
19	23/03/09	cash		-$40
BUDGET 2009 TRIP

Thanks
Pedro

 

[barry houdini]

So I assume that for your example H15 would be a sum of C15 and D15, i.e. -$239?

Perhaps in H15 copied down

=IF(B15="Visa",SUM(C15:F15),0)

 

[pedro-egoli]

Thanks Barry that worked well.

I changed the formula by replacing "0" with " "" " to get rid of the $0's in cells where no data entered in column B.
=IF(B15="Visa",SUM(C15:F15),"")
Any problem with this?

Thanks in advance for your response.

Pedro

 

[scottylad2]

Excel Workbook
	J	K	L	M
2
3	METHOD	Amount	Visa	Cash
4	cash	240	288	844
5	cash	44
6	cash	105
7	visa	146
8	cash	121
9	cash	94
10	visa	76
11	visa	21
12	visa	45
13	cash	107
14	cash	133
15
Sheet1

this works as well

 

[pedro-egoli]

Scotylad,
Thanks that looks interesting.
I have just posted another query on http://www.mrexcel.com/forum/showthread.php?p=1880309#post1880309

Your suggestion seems to cover part of what I am looking for (hiding previous sub totals), and I will work on summing these sub totals. .

Pedro

 

[pedro-egoli]

Finally sorted check this thread

http://www.mrexcel.com/forum/showthread.php?p=1880309#post1880309

Pedro