=XLOOKUP(lookup item, row or column to search in, data to return, )Ī simple one to start - how do I quickly convert US dates with a '.' separator, to UK format?
XLOOKUP is a new lookup function in the latest Excel versions, which is a superior replacement for VLOOKUP or INDEX MATCH if you’ve been using those before. No, you would need to add this as a manual column.Ĭould you please give a recap of the XLOOKUP function?
Is the consolidation able to reference the names of the tabs Mon, Tue, Wed? See our other webinars on PQ for more details. Secondly, you could add each dataset to the data model using Power Query (Data => From Sheet), and then create a new query that appends all of these into one. However this is a very manual process and won’t update if the source data is updated.
