• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

VLOOKUP Function ?

M

Murphy Durphy

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

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...
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top