I'm sure there is a simple way to do this but I can't figure it out. I
am using the spreadsheet as an inventory data base. In a nutshell, the
last part of the product identifying number is the price code. I enter
that number in a separate column. In another column I have to enter
the actual cost dollar amount of the item. Example: C = pricecode 7
H = $99.00. The price codes run from 0 - 27 with a corresponding
dollar amount for each. Is there a way I can format the sheet so that
when I enter the '7' or orther number in column C it will automatically
enter the $99.00 or other dollar amount in column H?
I'm sure this is easy for some but I am old and learning everyday!
Thanks
CC