Forum Discussion
Help with VLOOKUP formula for yesterday's data please
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, ...
I took the table you showed and produced the attached. It does use FILTER, as m_tarler suggests in his response.
I suspect he'd also agree that you could organize your data differently for more effective longer term use. The way you have it, I presume you're plugging a new column in each day in column B, moving all preceding data over one. In time, you'll run out of columns. Excel could work just as well with a new row added each day for each building and temp reading, in any order. Let Excel do "the heavy lifting" of extracting the data for each building for any two days. If that's of interest, let us know.
