DB Question

[Obandy13]

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!

 

[DRANDON]

I would use vlookup to populate your box portions up top. You may have to manipulate the string to lookup the EIN number to pull it out of Column C. like with the use of a form of =left(A2, Find(“ “,A2)-1)

 

[Obandy13]

I would use vlookup to populate your box portions up top. You may have to manipulate the string to lookup the EIN number to pull it out of Column C. like with the use of a form of =left(A2, Find(“ “,A2)-1)

I figured; I just don't remember how to do the 'All Time' calculation w/ a VLOOKUP... does that make sense? I'm looking it up by agent, but then I also need to Average all the values for that individual or Sum all the values depending on the KPI... even Rank a couple of the KPI's. Any ideas on that?