auto format help

  • Thread starter Thread starter coastalcarolina
  • Start date Start date
C

coastalcarolina

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
 
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
 
Back
Top