Forum Discussion
How can use Power Query as a VLOOPUP replacement.
Here is a similar approach but instead of returning results that match the current day it returns the results for the last day in the appended table (whether that's today, yesterday, etc...).
I'm not sure what you have in mind for the general/continued workflow. Are you planning to create a new tab for each day, then create a new query to pull the new table, then revise the append query to include the latest?
Using "Folder" as a data source could automate pulling in & appending new data, if you were to save a new workbook for each day in the same folder. Just an idea. Happy to elaborate.
I'm not sure if I'm blind but I cannot see where to attach a file as you both appear to have done. Here is a link to it anyway.
https://1drv.ms/x/s!AiAvVNTmKlkpiq5NrkrSAS5X1ppvew?e=S0kjmb
littlevillage Perhaps like in the attached revised file. I copied and pasted your desired result as values, since the XLOOKUP wouldn't work based on the revised query output.