Using Excel to Automatically Calculate

[jawaune]

Hello everyone. I am selling about two dozen health and fitness products for my business. I was hoping there was a way I could use excel to save time when calculating and adding up prices.

What I wanted was a way to type the name of a product in excel in colum A and have excel automatically enter the price for that product in colum B. I would need this feature to happen for about two dozen products.

Is there a way to make this happen and can someone please walk me through the process. Thanks so much in advance for your help and feedback.

Jawaune

[Cutter]

Here is the usual method

http://www.excelfunctions.net/ExcelVlookup.html

http://www.excelfunctions.net/Excel-...-Tutorial.html

[jawaune]

Thank you very much. This info was very useful and exactly what I was looking for. I have one more question. the "table_array" that I will be referencing is in colum A and B of sheet 2 but the formula itself is located on sheet 1. How do I tell the formula to reference sheet 2 for the table array?

Thanks again.

[martindwilson]

like this
=vlookup(a1,sheet2!,x1:z100,false)
=vlookup(a1,'my sheet name'!,x1:z100,false) you need 'xx xx' if sheet name has spaces

[Cutter]

Actually it's what martindwilson said except he left out the column number references and has commas after the sheet names. So his formulas should be:

=VLOOKUP(A1,Sheet2!A1:B100,2,false)
=VLOOKUP(A1,'my sheet name'!A1:B100,2,false)

He was working into the wee hours again!

[martindwilson]

ooops thats what comes of just typing straight into forum without double checking!and at 1:33 am filled with wine lol