T
tomhelle
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.
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.