I have a user who has made an Excel spreadsheet to track inventory that she
has in our gift shop. She has one column where she records a series of
letters that gets printed on a price tag, so the shop workers know what the
wholesale price of an item is. For example, she may enter CHC, which means
that the price is 2.72. What we need is some way to convert that CHC into
2.72 in another column. The values of the letters always remain the same,
for example, C=2, D=5, H=7, etc. Is there any way to write a formula like IF
column A = "C", then enter a value of 2 in column G, if column A = "D", then
enter 5, etc.?