Have a data table on sheet 2 as follows:

Material 1 Thickness 1 Price 1
Material 1 Thickness 2 Price 2
Material 2 Thickness 1 Price 3

On sheet 1, I will specify the desired Material and Thickness but need a
formula to lookup the associated price.

Example: If I specify Material 1 and Thickness 2, I want a result of Price 2.

Many thanks in advance.