Bill --

I think you ought to look at the CHOOSE function. The first argument is an
index number ('n'), and then there are 'n' different actions. CHOOSE picks
the nth action. So then the problem is that you've already set it up with
letters rather than index numbers (1, 2, 3, 4, 5). I 'd think you have two
choices, either find-and-replace all the letters with numbers, or create a
little lookup table where it looks up the index number based on the letter
you assigned.

HTH

"bill ch" wrote:

I would like to add multiple IF / VLOOKUPS to the formula below that
currently works. This site: http://www.cpearson.com/excel/nested.htm helps
but, I was planning on using the named formula to lookup '2006 IP Payer Mix
on Settled' vs '2005 IP Payer Mix on Settled'. Currently I have multiple
columns that search based on the IF(B31="*",) with "*" equalling various
letters. IS there a way I can combine these with an OR statement or am I
heading down the wrong path. Suggestions welcome, thanks. Please keep in
mind the file is large 28MB.


=IF(AC31=J31,J31*0.5,IF(D31=" ",VLOOKUP(C31,'2006 IP Payer Mix on
Settled'!H:I,2,FALSE)*K31,IF(B31="A",VLOOKUP(D31,' 2006 IP
Template'!B:C,2,FALSE),IF(B31="B",VLOOKUP(D31,'200 6 IP
Template'!B:G,6,FALSE),IF(B31="h",VLOOKUP(C31,'200 6 IP Payer Mix on
Settled'!H:I,2,FALSE)*K31,IF(B31="d",VLOOKUP(D31,' 2006 IP
Template'!B:Y,10,FALSE),IF(C31="D05",VLOOKUP(D31,' 2006 IP
Template'!B:Y,11,FALSE))))))))