Forum Discussion
IFS(AND()) ACROSS MULTIPLE WORKBOOKS
Hard to say....if it's possible for you to post copies or mock copies of several examples, we might be able to try different "tricks"
Absent that, I've successfully used FILTER to retrieve data from other workbooks, and it works with multiple complex criteria. It's a relatively new function, requiring the current version of Excel, but very powerful. Here's a link that explains it well.
Here in the original pic you can see the formula I am struggling with.
I am trying to get it to: (into cell E4:E50 on the original Worksheet) =IF the MUNI Page & ATS matches(*from the other 4 work books on any worksheet) to return the value in $C$2 of the matching worksheet(no matter which sheet matches).
**Also important to note, I will be adding more worksheets to each of the 4 Workbooks as needed.
Hopefully this makes sense & thank you for all the help.
This is far more complicated (from the appearance of things) than that first one, and on an altogether different set of data.
- May I, first, suggest you start a new thread...so that others are more likely to see it.
- Second, is it at all possible for you to grant us access to either the real spreadsheet(s)/workbook(s)..post them here, if you can, OR put a copy on OneDrive or in GoogleDrive or one of the other cloud services and then give us a link here. Just make sure that no confidential or proprietary info is included; no name of real people or businesses as well. So a mockup would also work......
- https://techcommunity.microsoft.com/t5/excel/ifs-and-across-multiple-workbooks-returning-data-from-matched/m-p/3591045#M157511
I started a new thread here and I attached mach workbooks similar to what I am using.
Thank you ahead of time.
