I have a workbook in which I will be calculating the cost of a foundation wall for a specific building. "Worksheet #1" has a table of costs per lineal foot based on the size of a concrete foundation wall. Column A lists "heights" from 1'0 to 16'0, while Row 1 lists "thicknesses" from 8" to 14".

"Worksheet #2" will have columns with a breakdown of any combination of wall height and thickness that pertains to that specific building. For example, cell A1 will have a value of "8"" and cell B1 will have a value of "9'0". I would like cell C1 to automatically show the cost per lineal foot of that wall based on referencing the table in "Worksheet #1".

How can I make Excel search Column A for the "9'0" then then search Row 1 for "8"" thus choosing the intersecting value of the row and column and entering into cell C1? That would then tell me the cost per lineal foot of an 8"x9'0 concrete wall.

I am familar with VLOOKUP and HLOOKUP, but not with how i can make them work together.

Any help would be greatly appreciated!!!

Thanks!!!