PLEASE HELP!! # of Nested If's - Have 7 but Excel Still Won't Acce

[Paige]

Can someone look at this and see why Excel won't accept this formula? Says
it contains an error and hilites the 2nd to last 'match' in the formula.
(Note: Range names are used throughout, and they are all valid.)

=IF(O3<>"","",
IF(L3=9,AT3,
IF(L3=10,OFFSET(SMBBASE,MATCH(G3,SMBPROD,0),MATCH(L3,SMBSL,0)),
IF(L3<5,OFFSET(SNTBASE,MATCH(G3,SNTPROD,0),MATCH(L3,SNTSL,0)),
IF(L3<9,OFFSET(SNTOSBASE,MATCH(G3,SNTOSPROD,0),MATCH(L3,SNTOSSL,0)),
IF(L3<15,OFFSET(IPSBASE,MATCH(G3,IPSPROD,0),MATCH(L3,IPSSL,0)),
IF(L3<19,OFFSET(IPSOSBASE,MATCH(G3,IPSOSPROD,0),MATCH(L3,IPSOSSL,0)),"")))))))

 

[PapaDos]

You can only use seven levels of nested functions in Excel.

 

[Teethless mama]

Use VLOOKUP function instead

 

[Paige]

Maybe that's why I'm confused; I only used 7 'if' statements, isn't that what
they are talking about re the 7 limit?

 

[JMB]

Your OFFSET(...MATCH(..)) adds two more levels.

 

[Paige]

Thanks, did not realize that. Thank you all for your help; have a great day!