Forum Discussion
XLOOKUP Help
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. However, I now need to add data from a new date. How can I adjust my XLOOKUP to only pull the data from a particular date? An example of one of the current formulas is XLOOKUP($C8,'DATA '!$B:$B,'DATA '!Z:Z). C8 is the refrence and DATAB:B is the reference column. My new date column is DATA!B:B.
If the new date column is B, what is the reference column now?
And which cell contains the specific date you want to look at?
- At the moment I have XLOOKUP($C8,DATA!$B:$B,DATA!Z:Z) which is XLOOKUP(reference number,refernce number column on other tab,return column). I want it to only pull this data when DATA!D:D is the same as a cell called ValDate
- Thanks for your response but i managed to fix it with an additional XLOOKUP for the date
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?
- I have a tab that pulls the database data and a tab for the client reporting. Client cannot see the database tab. Thanks for your response
