I'll try to explain this the best I can. Basically I have multiple tabs in a work book (Banks, Schools, Restaurants, Shopping center). The tabs has a list of services (HVAC, Electrical, Plumbing, Welding Etc.) and a $/sqft. So basically the average Banks, schools and restaurants will have different $/sqft when it comes to the services. I need to know if there is a way that I can insert a drop box to change which set of data my vlookup is pulling in.
I used a macro to get all data to a consolidated sheet.
After that i used a pivot table to show the data.
You can also use sumproduct for that.
You can also use Vlookup to get the data on another sheet.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I used a vlookup with an indirect.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks