Assigning values to letter???

B

Brian Preston

Hello All, here's what I want to do...

I want to assign a value to certain letters, or letter
number combos. Example: "D" would equal "7.5", "D2"
would equal "6", etc.. The reason is because I'm making
a work schedule, "D"'s equal "Days", which equal "7.5"
hours... I want to be able to have a bunch of cells full
of these letter and letter number combo's, and get a
total of hours worked...

Thanks in advance...

Brian Preston
 
T

Tom Ogilvy

Create a two column Table

D 7.5
D2 6


Then you can lookup the value
=Vlookup(A1,Table,2,False)
 
Top