Then, in the same function, you can add another query and specify cells, and pull data in from multiple places—it becomes an Xlookup on steroids. The function will only be available to Microsoft 365 ...

Find historical weather by searching for a city, zip code, or airport code. Include a date for which you would like to see weather history. You can select a range of dates in the results on the next ...