I am trying to build a formula were B2-B30 could contain three different office names E2-30 will contain dollar amounts which will be added in E31, 32 and 33 depending on office name in column B. can anyone help me with a formula?
E31 will have one name associated with it E32 will have another and E33 will have the third. depending which name you pick from the dropdown will determine which column it adds in @StanRuss69
