software

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
CCCreate a table of your price codes. You can even put it on a separate
worksheet. Use vlookup:
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;coastalcarolinaquot; gt; wrote in message oups.com...
gt; I'm sure there is a simple way to do this but I can't figure it out. I
gt; am using the spreadsheet as an inventory data base. In a nutshell, the
gt; last part of the product identifying number is the price code. I enter
gt; that number in a separate column. In another column I have to enter
gt; the actual cost dollar amount of the item. Example: C = pricecode 7
gt; H = $99.00. The price codes run from 0 - 27 with a corresponding
gt; dollar amount for each. Is there a way I can format the sheet so that
gt; when I enter the '7' or orther number in column C it will automatically
gt; enter the $99.00 or other dollar amount in column H?
gt; I'm sure this is easy for some but I am old and learning everyday!
gt; Thanks
gt; CC
gt;
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=quot;quot;,quot;quot;,VLOOKUP(C1,your_table,2,0))
your_table would be the range where you have the codes and price amount.

HTH
Jean-Guy

quot;coastalcarolinaquot; wrote:

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