Need help with making Excel choose from variables

[Joac1675]

I have these variables which is X meters and then the price change as you go up in meters and cross section
If the price is between 500-1500meters i cost 3.36 for a cross section 40cm^2
If the price is 3000 meters it cost 2.85 meters for a cross section 40cm


So i would like to make a code that automatically chooses the price if it's a 40mm cross-section and 499m e.g.

I attached an Excel with the variables

Anyone with ideas!

[Glenn Kennedy]

One way, of many:

=LOOKUP(2,1/($C$4:$C$7<D13),INDEX($D$4:$I$7,,MATCH(B10,$D$3:$I$3,0)))

[JohnTopley]

Another

=INDEX($D$4:$I$7,MATCH($D$13,$C$4:$C$13,1),MATCH($B$10,$D$3:$I$3,1))*$D$13