I need help! Drop down list, different choice - populates summary table!

[ollieshep]

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!

[AliGW]

Welcome to the forum.

There is no Excel 2018 - what do you have? Or is this some Mac version or other? Please clarify in your forum profile.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.