Looking for help with formula to lookup pricing

[aquapowers]

Hello experts, I'm looking for a formula for cell C3 that will lookup the material and quantity entered in cells A3 and B3. In the example provided, the quantity must be reached to get the price. The quantity of 50 is enough to reach the 48 quantity price of 297.71, but lower than the 100 quantity price of 283.28. There can be as few a one price break (item 88100 for example). If the minimum quantity is not reached, a price should not be populated in the resulting formula.

Contract Pricing 06.12.2024.xlsx
	A	B	C	D	E	F	G
2	Item	Quantity	Price		Item	price	quantity
3	88000	50	297.71		88000	308.48	20
4					88000	297.71	48
5					88000	283.38	100
6					88000	272.59	248
7					88000	265.41	500
8					88050	352.99	32
9					88050	323.87	48
10					88050	290.64	100
11					88050	270.66	240
12					88100	195.76	48
13					88750	275.32	30
14					88750	258.08	100
15					88750	250.38	250
16					88750	239.6	600
Sheet1

 

[Cubist]

This assumes the price is same or cheaper higher quantity. Secondly, it'll show the price as 0 if the requirements are not met. Try

Book1
	A	B	C	D	E	F	G
1
2	Item	Quantity	Price		Item	price	quantity
3	88000	50	297.71		88000	308.48	20
4					88000	297.71	48
5					88000	283.38	100
6					88000	272.59	248
7					88000	265.41	500
8					88050	352.99	32
9					88050	323.87	48
10					88050	290.64	100
11					88050	270.66	240
12					88100	195.76	48
13					88750	275.32	30
14					88750	258.08	100
15					88750	250.38	250
16					88750	239.6	600
Sheet3

Cell Formulas
Range	Formula
C3	C3	=MINIFS($F$3:$F$16,$E$3:$E$16,A3,$G$3:$G$16,"<="&B3)

 

[aquapowers]

You nailed it! Thank you for support Cubist.