Quote Originally Posted by segehring
Can you explain this a bit more? I'm not sure what this is for. The VLOOKUP works for all of the worksheets except the Material Specification worksheets. (10 SST, 11 SST, 15 Steel, 16 Steel, 20 Copper, 22 Brass, 24 Bronze, 30 Aluminum, 31 Aluminum, etc.)

I reposted with the formulas already in place. They can be found in Column J, Rows 4-8 on the Data Entry worksheet.

Until I can get the VLOOKUP command to work with the mat. spec. sheets, I am leaving out the if() statement.

Thanks

Shane
Put the lookup tabe that I gave you in T2:U16, and then use

=VLOOKUP(--D4,INDIRECT("'"&VLOOKUP(--A4,T2:U16,2,FALSE)&"'!A:$B"),2,FALSE)