How to Question: Lookup then multiplication depending on range

[neilenty]

Hi Everyone

I'm a bit stuck

I want to create a calculation whereby I input length and width in two cells, which then automatically calculates area in another, then depending on that area (within a range) it generates another number.

For example
Length Cell C3 = 1000m
Width Cell C4 =300m

Cell E5 =C3*C4 (300,000)
Cell G5 =E5 - looks up range and if less than 25,000 = 100, between 25,000 and 50,000 = 200 etc.

25000​

50000​

100000​

300000​

500000​

750000​

1000000​

Also then need to do the same but with letters

I input a letter in C7 and it looks that letter up in a range of 6 and depending on that letter it multiplies the result in G5 by 25%

Many thanks in advance

N

 

[CA_Punit]

25000500001000003000005000007500001000000​

What incremental lookup values does the range have. Eg as you said for 25000-50000 it 200. so for 50000---100000???

Also

Also then need to do the same but with letters

It will require a sample data..

 

[Fluff]

Maybe, something like

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2									0	100
3			1000						25001	200
4			300						50001	300
5					300000		400		75001	400
Main

Cell Formulas
Range	Formula
E5	E5	=C3*C4
G5	G5	=VLOOKUP(E5,I2:J5,2,1)

 

[neilenty]

? the Vlookup table works great! and works with the letters too... thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.