You should set up a table, e.g. items in Y1:Y10 and corresponding costs in
Z1:Z10
then use this formula in B1

=VLOOKUP(A1,$Y$1:$Z$10,2,0)

"Amey_zing1" wrote:

I would like to format my spreadsheet so that when I enter a word in one cell
it automatically inputs a value in another cell. For example: (if cell
A1="Blue Shirt" then cell B1=4.39, if cell A1="Red Shirt" then cell B1=5.19)
...and so on. This way Excel can automatically tally the cost of the item I'm
putting in and give me that value in the adjasent cell. I've seen it done, I
just can't remember how. Help!