Hi!
I’m asking for help creating a formula that pulls Yesterday’s data into another spreadsheet. I pull an excel report that lists by column today’s data, yesterday’s data, the previous day’s data, and so on. I want to pull both today’s and yesterday’s data into a new spreadsheet. The rows are separate buildings., ex Building 1, Building 2, Building 3.
Currently I can pull today’s data no problem using VLOOKUP; how can I pull the next column when yesterday’s date will always change? Please help!

Adding a screen shot of the report.

Building09/11/202409/10/20247K-51123.4 deg24.2 deg550-1418.3 deg 20K-0123.9 deg 350-0717.8 deg 7K-515 24.9 deg7K-51324.5 deg24.4 deg7K-51424.5 deg 7K-51524.9 deg 7K-51224.7 deg 

​Hi!I’m asking for help creating a formula that pulls Yesterday’s data into another spreadsheet. I pull an excel report that lists by column today’s data, yesterday’s data, the previous day’s data, and so on. I want to pull both today’s and yesterday’s data into a new spreadsheet. The rows are separate buildings., ex Building 1, Building 2, Building 3.Currently I can pull today’s data no problem using VLOOKUP; how can I pull the next column when yesterday’s date will always change? Please help! Adding a screen shot of the report.Building09/11/202409/10/20247K-51123.4 deg24.2 deg550-1418.3 deg 20K-0123.9 deg 350-0717.8 deg 7K-515 24.9 deg7K-51324.5 deg24.4 deg7K-51424.5 deg 7K-51524.9 deg 7K-51224.7 deg   Read More

​