Nested IF Syntax Error

[KirkM]

Hi All,

I am using Excel 2013.
Trying to Nest 10 IF Statements but getting a syntax error.
The following are what I am try to Nest only using 3 as example:

IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR")
IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR")
IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")

When I combine them:
IF(B7="No Adhesive",(B6+Sheet1!B9),"ERROR"),IF(B7="1 x 6/9mm SP",(B6+Sheet1!B10),"ERROR"),IF(B7="2 x 6/9mm SP",(B6+Sheet1!B11),"ERROR")

Not Working...tried various additions of parentheses no joy.
Grateful for any help.
At the moment dabbling in vlookup but results are iffy.
Thanks

 

[njimack]

=IFERROR(B6+INDEX(Sheet1!B9:B11,MATCH(B7,{"No Adhesive","1 x 6/9mm SP","2 x 6/9mm SP"},0)),"ERROR")

 

[KirkM]

Perfect Thanks.