Calculate formula base of list menu

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate formula base of list menu

09-20-2010, 10:07 AM

Kimberly

Windows 7

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

=HLOOKUP(E6,$A$2:$C$3,2,0)*D6
in cell G6 and copy down

By the way, you are multiplying in column G, but doesn't the label in cell G5 imply division?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't calculate formulas	Cpat	Excel	2	06-09-2010 02:07 PM
How do I set up the fields in mail merge word 07 from my data base	mbcrabber	Mail Merge	4	06-06-2010 01:25 PM
Need help creating a data base for mail merge.	acedking90	Mail Merge	0	07-27-2009 11:04 AM
Calendar Base	prayojana	Project	0	11-12-2007 01:13 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:06 AM.