How to use a name to represent a dollar amount
 

For example, in colume A2 I have the item name carrot, and in B2 the dollar
amount of $0.90, how do I tie the two together? The reason being because on
another sheet in the workbook, I want to be able to take only the item name
and multiply by quantity to get the total cost? Can somebody please tell me
the formula for this action?

How to use a name to represent a dollar amount
 

Say in your new sheet... in cell A2 You have carrot and in cell b2 you have 5.

The 5 is the quantity

In cell C2 you would type the formula

=Vlookup(A2,Sheet1!$A$2:$B$100,2,FALSE)*B2

The vlookup formula checks for carrot in Sheet1. It would be easiest for you
to hilight the range of data you have in sheet1 rather then typing it out...
and if sheet1 isn't the name change the name. Make sure you keep the $ signs
around the cells.

"Item Manager" wrote:

For example, in colume A2 I have the item name carrot, and in B2 the dollar
amount of $0.90, how do I tie the two together? The reason being because on
another sheet in the workbook, I want to be able to take only the item name
and multiply by quantity to get the total cost? Can somebody please tell me
the formula for this action?