- Aug 12, 2003
- 1,248
- 0
- 0
I'm doing an excel project and I need to use the VLOOKUP function using the following chart (It extends out for a few years)
Year 1
Ford Mercury Saturn
Depreciation $8,629 $7,454 $6,158
Fuel Cost $1,167 $1,261 $1,349
Finanacing $1,493 $1,625 $1,305
Insurance $1,252 $1,287 $1,153
Maintenance $245 $247 $345
Fees, Taxes -$669 $118 $387
Repairs $0 $0 $0
Opportunity Cost $275 $339 $316
Year Total $12,392 $12,331 $11,013
How can the VLOOKUP function be used for something like this?
Year 1
Ford Mercury Saturn
Depreciation $8,629 $7,454 $6,158
Fuel Cost $1,167 $1,261 $1,349
Finanacing $1,493 $1,625 $1,305
Insurance $1,252 $1,287 $1,153
Maintenance $245 $247 $345
Fees, Taxes -$669 $118 $387
Repairs $0 $0 $0
Opportunity Cost $275 $339 $316
Year Total $12,392 $12,331 $11,013
How can the VLOOKUP function be used for something like this?
