Drop Down Box Look Up Problem

My first thought would be Vlookup

If this does not satisfy your requirements then maybe attach a small sample workbook with your expected results.

TABLE LOOKUP.xlsx

Unless I missed an example, I have attached my worksheet i am working on.

The table attached shows where the 3 drop downs need to find the cell that matches the same information and return to the ? cells

I Have completed the missing cells, hope this helps explain better,

Many thanks

Maybe this will work for you.

In A7 I added data validation because it seems it was required to make this work and in C5 added an If statement just to show you that sometimes the Length of Slate and Width of Slate will not match.

Since Length of Slate and Width of Slate have the possiblity of not matching I added the IFERROR to mask #N/A. If you want the #N/A to show then change the formula back to...

CTRL + SHIFT + ENTER
=INDEX($C$16:$S$31,MATCH(1,($B$1=$A$16:$A$31)*($B$2=$B$16:$B$31),0),MATCH($B$3,$C$15:$S$15,0))

IMPORTANT
This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

Thanks Jefferey & Ratcat, put the finishing touches to my work book, both valued contributors.

Max

The Work book is a work in progress, with a few more Calculations in Roof Calculator and Index and cell protection.

Feel free to scrutinse