no that doesn't work I need something more like this IF(e2=vt-481(VLOOKUP(B10,'Glass Data'!$A$2:$H$13,3,FALSE)),(IF(e2=vt-47(VLOOKUP(B10,'Glass Data'!$A$2:$H$13,3,FALSE)))))
So if cell e2 equals a certain name, I need the cell i'm writing the formula for to reference a table based on b10 name so if e2=vt-47 then if cell b10 reads 1080 VT-47 it looks up a number in a table in the third column but I have 4 types of material VT-47,VT-42, VT-481, VT-901 so its just reads all the way down with the styes 106 vt-47 then once those are done the table starts into the vt-481 then vt-901. So E2 reads the material type VT-??? based on that b10 reads the style 106-VT47... the in the cell i'm writing the formula I need it to read if 106 VT-47 is selected 1.3? Let me know if that makes sense at all? Thanks for all the help.
106 vt-47 5 1.3
1080 vt-47 5.5 2.1
2213 vt-47 4.5 3.3