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 ...
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
Thanks for your response but i managed to fix it with an additional XLOOKUP for the date
Wonderful. It's always satisfying to get a working solution. It sounds as if you now have either sequential or nested XLOOKUP references (XLOOKUP within XLOOKUP). You might benefit from some of the newer functions, such as FILTER, which can in one formula retrieve either multiple rows or single rows, and use multiple criteria. And this more comprehensive list of the myriad functions for looking up tabular data might also be worth studying.
