Forum Discussion
Help with VLOOKUP formula for yesterday's data please
Just following up on the suggestion that a slight redesign might serve you well.
This takes advantage of two semi-advanced features of Excel
- a table (which enables you to add new rows and have the new rows automatically included in any analyses)
- a data validation list so that you can just select the building code from the list; it also ensures it's entered correctly
And here's a piece of unsolicited advice: just enter the number under the temp column. We know it's a measurement in degrees, so those are just unnecessary additional keystrokes.
mathetes Thank you so much for the quick reply and assistance! Apologies if my original post wasn't clear or didn't provide enough information. The report I am pulling is from external software that I currently don't have ability to change layout, so I'm working with what I have shown. No additional keystrokes for "deg" either, that's how it's populating.
The piece I can't figure out (and again apologies this wasn't clearer) is that I'd like to pull yesterday's temperature into a new Master tab, that pull referencing the Building name. It's why I am using VLOOKUP for other pieces of information; the VLOOKUP value is my building name.
I have several different systems collecting data on each building; they all have the ability to export reports into Excel forms but don't talk to each other otherwise. I'm building a Master spreadsheet that compiles all data based on building, so I can export from systems each morning and have a clear picture.
Thanks again for all your help.
So the first example I gave you should give guidance as to how to achieve what you want. Just do that "FILTERing" on a different page. I appreciate that you think VLOOKUP is the answer, but be assured that is but one way--albeit a very popular one, having been around since the infancy of spreadsheets--to retrieve information according to criteria. Here's a resource of many others. I have found, however, that FILTER often works in precisely the situation you're in.
Having said all that, are you in a position to share an actual example of the raw data you're working with? Seeing that more comprehensive picture might help us help you. You may be able to attach file(s) directly below the text box into which you enter your inquiries and responses. Otherwise, posting them on OneDrive or GoogleDrive with links here that grant access is effective as well.
