Thanks for the reply .... I am not well versed with the lookup function. I am attaching a sample worksheet that shows the formulas I am using. The yellow fields are the base values and the blue fields are the adjusted values that are derived from senario manager. Teh range fields are where senario manager makes the changes then the blue fields re-calculate and thus the new charges appear.

Attached Files

ProblemSheet.xls (304.5 KB, 11 views)