How to use a name to represent a dollar amount

I

Item Manager

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?
 
A

akphidelt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto populating a cell based on another cell for an invoice 3
Input dollar amount into a cell that updates another cell and more 7
Windows XP Array / SUMPRODUCT error 0
Sum Dynamic Range 2
how do i make a formula to multiply two values? 6
formula to look up and sum the Grand totals based on the Heading 4
template creates invoice - how to create summary worksheet? 13
Data Validation and total Sum???? 1

Top