Hello,

Is there a formula which will sole my problem, I canto do it and its sending me crazy

I have two sets of costs on different tabs. One for 'Building A', and one for 'Building B'.

I want to pull these costs to column on a summary sheet by choose Building A or Buidlign B from a drop down list. So If I choose 'Building A' from the drop down list I want that set of costs to pull through. However, If I change my drop down list value to 'Building B' I want the rates to change in my summary.

So my summary table will change depending if I choose 'Building A'. or 'Building B' from drop down list.

Thank you!