Don't feel bad, figuring out how many closing parenthesis and where they need
to be is a continuing problem around my house also. Glad you got it working.
Usually better to have something working that you understand than to have
something working that, should it break, you'd have a dickens of a time
repairing. That's one reason I sometimes stick with the "old ways" rather
than jumping on some suggested esoteric code in a MSFT KnowledgeBase article.

"tlosgyl3" wrote:


Gentelmen - my apologies. Your are corresponding with a man who can't
count brackets. Once corected to
=IF(AM2<0,(IF($F2="YN",((INDEX(High!$C$2:$D$45,MA TCH(AM2,High!$C$2:$C$45,),MATCH(BM$1,High!$C$2:$D$ 2,)))),IF($F2="YY",((INDEX(High!$E$2:$F$45,MATCH(A M2,High!$E$2:$E$45,),MATCH(BM$1,High!$E$2:$F$2,))) ),IF($F2="NN",((INDEX(Std!$C$2:$D$45,MATCH(AM2,Std !$C$2:$C$45,),MATCH(BM$1,Std!$C$2:$D$2,)))),IF($F2 ="NY",((INDEX(Std!$E$2:$F$45,MATCH(AM2,Std!$E$2:$E $45,),MATCH(BM$1,Std!$E$2:$F$2,))))))))),0)

It computes correctly

tlosgyl3http://www.excelforum.com/images/smilies/eek.gif



--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=559277