Assigning Numbers to Words

[emagdnim]

I am writing a sheet for customers of ours to track their keg costs and profits.

I want the number of ounces in a particular keg to automatically populate the cells next to the cell where I input the keg size, i.e., Half=1984, Qtr= 992, Sixth=665, 20L=676, 30L=1014, 50L=1691


How do I do this?

[etaf]

you can use a vlookup to do that

so on a separate sheet you could have the list
and then lookup the values

i have also used the lookup table to add a data validation

look at cell A2 - change dropdown
then B2 will return the result using the lookup on sheet2

I'm also sure you can just add one formula to do the lookup - but brain fade - cant think of it

see attached

worked it out for just one formula

=LOOKUP(E5,{"20L","30L","50L","half","qtr","sixth"},{676,1014,1691,1984,992,665})

NOTE for lookup it has to be alphabetical order - hence the order I listed - see sheet 1 cell A4 for this version