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))))))))