Goal: Named formulas in CHOOSE need to be Relative references when pasted
down rows.

Example: I have a CHOOSE formula of
=IF(AC31=J31,J31*0.5,CHOOSE(B31,("A","B","H","D")) )

When I paste this down the rows it will do a relative reference for AC31,
J31 and B31 by changing them to AC32, J32, and B32 and so on. My problem is
it won't make the named formula references:("A","B","H","D") relative
references. The Named Formula's a
"A" =VLOOKUP(D31,'2006 IP Template'!B:C,2,FALSE)
"B" =VLOOKUP(D31,'2006 IP Template'!B:G,6,FALSE)
"H" =VLOOKUP(C31,'2006 IP Payer Mix on Settled'!H:I,2,FALSE)*K31
"D" =VLOOKUP(D31,'2006 IP Template'!B:Y,10,FALSE)
The ultimate goal is: How can I get these named formulas to also be relative
references?? When in row 32 I need these to look at D32, C32 and K32.
Thanks