Automatic Cell Assignment in Microsoft Excel?

Will1

Member
Joined
May 13, 2008
Messages
681
Reaction score
0
Points
16
I have an excel sheet for mileage. Most of the mileage values are the same given the destination. Is there a way for excel to automatically assign a preset numerical value based on the text input? (e.g. if I write "work", can I have excel automatically put in 16 miles?)
 
Back
Top