Excel won't allow more nesting issue!!!

[swagyolo]

My formula is: =G4+IF(K3=1,GETPIVOTDATA("Sum of 1EL",$A$10),IF(K3=2,GETPIVOTDATA("Sum of 2EL",$A$10), IF(K3=3,GETPIVOTDATA("Sum of 3EL",$A$10), IF(K3=4,GETPIVOTDATA("Sum of 4EL",$A$10), IF(K3=5,GETPIVOTDATA("Sum of 5EL",$A$10), IF(K3=6,GETPIVOTDATA("Sum of 6EL",$A$10), IF(K3=7,GETPIVOTDATA("Sum of 7EL",$A$10), IF(K3=8,GETPIVOTDATA("Sum of 8EL",$A$10), IF(K3=9,GETPIVOTDATA("Sum of 9EL",$A$10))))

Everytime I try and use this, it says that I am unable to use it in my current version of excel. I tried switching to an XML, but I wasn't allowed to do that either.

 

[Scott Huish]

I've never used that function, but does this work for you?

=G4+GETPIVOTDATA("Sum of "&K3&"EL",$A$10)

I'm not sure, you might need INDIRECT with that:

=G4+GETPIVOTDATA(INDIRECT("Sum of "&K3&"EL"),$A$10)

 

[swagyolo]

Wow. Yes it does. Thank you so much.