Forum Discussion
Caitlin Crump
Jan 04, 2018Copper Contributor
PLEASE HELP with Vehicle Weight Formula
Hello,
I work with cars and spreadsheets, and I would like an automated way of filling in a car's weight. For example, a Ford Lobo is always 2236 kilos, and a BMW X5 is always 2265 kilos.
...
Haytham Amairah
Jan 04, 2018Silver Contributor
Caitlin,
The best solution in my opinion - especially when you have many cars - is to create a table of car weights in a separate sheet, then use VLOOKUP function to look into this table and retrieve the car weight, you can put VLOOKUP somewhere in the main sheet.
Please find the supposed solution in the attachment file.