Expanding a function

[moomphas]

Hello,

I cannot expand this function, so that it looks for values in G if E is blank, and I if G is blank:

=IF(IF(Sheet1!A1="",Sheet1!C1,Sheet1!A1)="",Sheet1!E1,IF(Sheet1!A1="",Sheet1!C1,Sheet1!A1))

It just looks for the first non-blank cell in Sheet1 (A,C,E,G,I)

Anyone?

[Bernie Deitrick]

=if(a1<>"",a1,if(c1<>"",c1,if(e1<>"",e1,if(g1<>"",g1,i1))))

[moomphas]

Awesome, mate! Thanks a ton!