# Help with Vlookup formula

#### pedro-egoli

##### Well-known Member
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.

Thanks
Pedro

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### barry houdini

##### MrExcel MVP
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

##### Well-known Member
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?

Pedro

##### Well-known Member
Excel Workbook
JKLM
2
3METHODAmountVisaCash
4cash240288844
5cash44
6cash105
7visa146
8cash121
9cash94
10visa76
11visa21
12visa45
13cash107
14cash133
15
Sheet1

this works as well

Replies
2
Views
681
Replies
1
Views
559
Replies
17
Views
1K
Replies
4
Views
344

1,191,166
Messages
5,985,051
Members
439,935
Latest member
Monty238

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