Forum Discussion
AnnMitchell855
Oct 31, 2024Copper Contributor
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 ...
HansVogelaar
Oct 31, 2024MVP
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?
AnnMitchell855
Oct 31, 2024Copper Contributor
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
- AnnMitchell855Oct 31, 2024Copper ContributorThanks for your response but i managed to fix it with an additional XLOOKUP for the date
- mathetesOct 31, 2024Gold Contributor
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.