Missing Parenthesis

[kcroft88]

Hi,

My Excel formula is returning and error that I ant seem to figure out, can anyone advise?

Here I my formula:

=IF($B$2="GS12UV",'X2001 WIP Targets (2)'!F3,IF($B$2="GS12CS",'X2001 WIP Targets (2)'!G3,IF($B$2="GS12C",'X2001 WIP Targets (2)'!H3,IF($B$2="GS6UV",'X2001 WIP Targets (2)'!I3,IF($B$2="GS6CS",'X2001 WIP Targets (2)'!J3),IF($B$2="GS6C",'X2001 WIP Targets (2)'!K3,IF($B$2="GS40UV",'X2001 WIP Targets (2)'!L3,IF($B$2="GS40CS",'X2001 WIP Targets (2)'!M3,IF($B$2="GS40C",'X2001 WIP Targets (2)'!N3,IF($B$2="Combined",'X2001 WIP Targets (2)'!O3,)))

Regards,

 

[steve the fish]

Hi,

My Excel formula is returning and error that I ant seem to figure out, can anyone advise?

Here I my formula:

=IF($B$2="GS12UV",'X2001 WIP Targets (2)'!F3,IF($B$2="GS12CS",'X2001 WIP Targets (2)'!G3,IF($B$2="GS12C",'X2001 WIP Targets (2)'!H3,IF($B$2="GS6UV",'X2001 WIP Targets (2)'!I3,IF($B$2="GS6CS",'X2001 WIP Targets (2)'!J3),IF($B$2="GS6C",'X2001 WIP Targets (2)'!K3,IF($B$2="GS40UV",'X2001 WIP Targets (2)'!L3,IF($B$2="GS40CS",'X2001 WIP Targets (2)'!M3,IF($B$2="GS40C",'X2001 WIP Targets (2)'!N3,IF($B$2="Combined",'X2001 WIP Targets (2)'!O3,)))

Regards,

Delete this bracket ive highlighted.

 

[Rick Rothstein]

Steve has given you the fix for the formula you posted. This is untested, but I am pretty sure the following formula will do the same thing you posted formula was supposed to do...

[table="width: 500"]
[tr]
	[td]=OFFSET('X2001 WIP Targets (2)'!F3,0,(FIND(LEFT(B2&"      ",6),"GS12UV,GS12CS,GS12C ,GS6UV ,GS6CS ,GS6C  ,GS40UV,CS40CS,GS40C ,Combined")-1)/7)[/td]
[/tr]
[/table]

Edit Note
------------------------
The above formula is Volatile. Still untested, but I believe this non-Volatile formula will also work...

[table="width: 500"]
[tr]
	[td]=INDEX('X2001 WIP Targets (2)'!F3:O3,,(FIND(LEFT(B2&"      ",6),"GS12UV,GS12CS,GS12C ,GS6UV ,GS6CS ,GS6C  ,GS40UV,CS40CS,GS40C ,Combined")+6)/7)[/td]
[/tr]
[/table]