pedroegoli
Wellknown Member
 Joined
 Apr 25, 2004
 Messages
 1,217
 Office Version

 2016
 Platform

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