B
bill ch
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 are:
"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
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") relativereferences. The Named Formula's are:
"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