=IF(ISNA(VLOOKUP(C2,INDIRECT(VLOOKUP(R5:S8),2*C9)) ),TRUE))
The formula above requires modification.
R5:S8 is also a table named "Max_Weight_Table" which has four selections of
materials in R5:R8 and weights in S5:S8.
When C2 matches a material in column R it should multiply the corresponding
weight by C9.
Can someone help please.
Thank you in advance.
I need to be away for two hours. I will check when I come back.
Serge