Find Suitable sheet material to produce panel size

Hi Guys,

Can anyone help with the attached Worksheet?
I'm basically looking to find the most economical sheet size to produce a panel (1 panel per sheet only for now) but am really struggling with a formula that will compare all the required criteria:

Manufacturer & Type & Thickness to match exactly
AND
Panel height to be less than Sheet height
AND
Panel width to be less than Sheet width
THEN
Use the cheapest panel left from the selection

Any help would be great, I'm currently trying to nest INDEX & MATCH formulas but so far everything I've tried has returned an error.

Brilliant John, thank you.

As always seems to be the case though, I've got the answer I asked for but not the one I actually needed!
I will try to add an offset to your formula so it returns sheet height, width & Price across 3 cells.

Also, thank you for not pointing out my deliberate mistake in the description of column A

I'll mark this as solved as soon as I can incorporate it into the actual scheduler.

Lee

for height/width

with Price in M3

in N3

=INDEX(E$3:E$100,MATCH($M3,$G$3:$G$100,0))

in O3

=INDEX(F$3:F$100,MATCH($M3,$G$3:$G$100,0))

Ok I give in!

Can someone remind me why I spend hours juggling formulas & trawling 'Tinternet to try and stumble upon an answer that you guys can work out in minutes????

It's very Tempting just to put the whole project on here & let an expert deal with it.......but I MUST try to learn

Thanks Again John All three formulas work perfectly.

You are very welcome.

Yes ... you have to learn ( myself included) and this forum is an excellent source of "learning" so try and make regular visits and look at some of the responses.

Try having ago yourself but rather then spend hours trawling the net, post your query here.