Forum Discussion
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.
I would like to have it so that if, say A13, has "FORD LOBO" as text, then F13 will automatically put "2235 KGS". And I would like the same to be done if "BMW X5" is put into A13, B13, C13, etc, then F14, then F14 would automatically put "2265 KGS". Is there a way to do this? There are 24 cars to choose from. Thanks!
1 Reply
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.
