auto format help
 

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

auto format help
 

Create a table of your price codes. You can even put it on a separate
worksheet. Use vlookup:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"coastalcarolina" wrote in message
oups.com...
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

auto format help
 

Use a VLOOKUP formula, start by creating your table if you have not yet done
so, column 1 enter the codes, column 2 enter the corresponding $ amount. Now
in column H type:
=IF(C1="","",VLOOKUP(C1,your_table,2,0))
your_table would be the range where you have the codes and price amount.

HTH
Jean-Guy

"coastalcarolina" wrote:

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