Hey everyone! I'm trying to make a simple quick dashboard that will return all the ratio's I'm looking for from a single spreadsheet. The look doesn't matter, but essentially I'm trying to look up two values: Yesterday's value, and the 'All Time' value. I want it to look something like this:
The source spreadsheet already has this data by date and Name:
I've done this before but it was 10 years ago and I used some form of INDEX/MATCH to get the job done. Can anyone give me a hand? I'm sure it's the same formula for each value I want to return. Thanks in advance!
The source spreadsheet already has this data by date and Name:
I've done this before but it was 10 years ago and I used some form of INDEX/MATCH to get the job done. Can anyone give me a hand? I'm sure it's the same formula for each value I want to return. Thanks in advance!