VLOOKUP Function ?

Murphy Durphy

Golden Member
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?
 

PowerEngineer

Diamond Member
Oct 22, 2001
3,615
799
136

I prefer to use MATCH and INDEX for these kinds of things myself, but if you have to use VLOOKUP...

I presume the look-up value is the brand of automobile. If so put then in the first column in alphabetical order and then add their other information (e.g. depreciation, fuel economy, etc.) in columns to the right. Should be easy from there...