Forum Discussion
XLOOKUP Help
You've written:
I have a spreadsheet that uses XLOOKUP to pull data from one tab into another. I have matching references on each tab to identify the data.
I'm sure HansVogelaar can help with the XLOOKUP. My concern--which you are entirely free to ignore--is always heightened when I read references to multiple tabs. Not that multiple tabs are always or inherently inappropriate (some of my own spreadsheets make extensive use of multiple tabs), but they often can make things more complicated than necessary, requiring more complex maintenance, etc.
So my concerns gets at fundamental design. As I said, you are free to ignore the questions, the concern. But both HansVogelaar and I often find that seeing the workbook, when possible, helps not only fix a single formula (XLOOKUP or something else) but also perhaps offer suggestions for far smoother operations in general. Is it possible for you to share either the actual workbook or a mockup (concealing private or confidential data) so we could take that look. Short of that, would you be willing to verbally describe the multiple tabs, why they're needed, how they're used?
