Forum Discussion
Renaming a cell while retaining its value
Hello All, I'm a bit of a new Excel user so forgive me if I don't use the correct terms. I have been putting together a table that will show net cost for an upgraded vehicle purchase when factori...
that is correct that you can't have the car name there but the value be something else. There are many things you can do with defining 'names' but not in the way you are requesting and not that I would recommend. That said, I would simply add another column so you have a column called Car with the drop down with Car Names and then a column called Cost and use a simple XLOOKUP (or another lookup if you prefer) and grab the price for that car from the other table.
Thank you for the response!
