Forum Discussion

Andrew Lindsay's avatar
Andrew Lindsay
Tin Contributor
Feb 14, 2019

How to return multiple results based on multiple criteria

I'd like to return data from multiple worksheets based upon multiple criteria.  Here is an example: Data Table 1 (in worksheet 1) Item Location Qty this east 5 that west 10 anothe...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 14, 2019

Instead of macro that could be done by Power Query - query all your tables, combine them, filter on criteria and land the result back to the sheet.

  • Andrew Lindsay's avatar
    Andrew Lindsay
    Tin Contributor
    Feb 18, 2019

    Sergei, Power Query may be the way for us to go. I see it will perform the functions we need. However, although our company has access to Power BI through our Office 365 for Business subscription, I'm not sure that our client has access. I haven't reviewed the material on the functionality, but if I understand correctly workbooks we create using the Power Query functionality won't be able to be used by another unless they also have an Office subscription that contains the functionality. Is this correct?

    Thanks again,
    Andrew