If, Then Statement....?

[Anthony G.]

Hello To All:

The user will enter data into cells that fall within columns A:C, which will then put the formulas in column D to work. Cells in column E will use Data Validation in order to allow the user to select from a list of disciplines. Currently, cells A10:B13 house the disciplines and their cost, which allows the formulas in column F to work only if done manually. The goal is to place a formula into the cells in column F that would automatically perform the calculation once the user selects the desired Discipline from the drop-down menu...is that possible?

Thanks...Anthony

******** ******************** ************************************************************************>

Microsoft Excel - Book2 ___Running: xl2002 XP : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
D2F2D3F3D4F4D5D6D7 =
	A	B	C	D	E	F
1	District	Total*Enroll	Grades	Adopt*Enroll	Discipline	Cost
2	Cuba*City*School*District	276	2	79*	Reading	$7,886*
3	Milwaukee*-*Private	85	7	85*	Language*Arts	$6,375*
4	Erin*School*District	266	4	152*	Science	$7,600*
5	Racine	262	6	225*	Reading	*
6	Waukesha*-*Private	220	7	220*	Health	*
7	Grant	79	6	68*	Science	*
8	*	*	*	*	*	*
9	*	*	*	*	*	*
10	Reading	$100	*	*	*	*
11	Language*Arts	$75	*	*	*	*
12	Science	$50	*	*	*	*
13	Health	$25	*	*	*	*
Sheet1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[onlyadrafter]

Hello

Try in F2,

=D2*VLOOKUP(E2,$A$10:$B$13,2,0)

Does this work? (I haven't tested it).

This is not necessary.

Sorry, forgot to mention to sort A10:B13 in ascending order by Col A.

[onlyadrafter]

Hello

Brian,

I wrote this, incorrectly obviously, because I only found out about the ,0 at the end of the VLOOKUP.

But thank you for correcting me, much appreciated, something else I have learnt.

WHERE HAS YOUR POST GONE?

[DRJ]

=SUMPRODUCT(($A$10:$A$13=E2)*($B$10:$B$13)*(D2))

[Aladin Akyurek]

Sort A10:B13 on its first column, which would enable to use a fast lookup formula in F2...

=D2*LOOKUP(E2,$A$10:$B$13)

or, A10:B13 as is, a SumIf formula in F2...

=D2*SUMIF($A$10:$A$13,E2,$B$10:$B$13)

which is also fast.

[Anthony G.]

...And fast it was - Thank You...Thank you All!

Anthony