IF Statement

[funkeycooldude]

Hi there,

Can anyone please help me shorten this IF statement:

=IF((C29=S27),S7,IF((C29=R27),R7,IF((C29=Q27),Q7,I
F((C29=P27),P7,IF((C29=O27),O7,IF((C29=N27),N7,IF(
(C29=M27),M7,IF((C29=L27),L7,IF((C29=K27),K7,IF((C
29=J27),J7,IF((C29=I27),I7,IF((C29=H27),H7,IF((C29
=G27),G7,IF((C29=F27),F7,IF((C29=E27),E7,IF((C29=D
27),D7)))))))))))))))))

The reason why I need this shortening is because Excel says I can only
have 7 IF statements.

Many Thanks,

 

[Max]

It looks like you could just use:
=INDEX(D7:S7,MATCH(C29,D27:S27,0))

 

[T. Valko]

Try this:

=IF(COUNTIF(D27:S27,C29),INDEX(D7:S7,MATCH(C29,D27:S27,0)),"")