Return a Value On Two Criteria

I have a master data spreadsheet and a summary cover. The master contains a list of names as the rows and dates as the columns. The data in the cell is sales.

On the summary, I have the names as the rows, then this week and last weeks ending date as columns. These are calculated using =TODAY() and =TODAY()-7.

I would like the cover sheet to do some kind of look up to the master data, to look up by name, then return last weeks and this weeks values. I know these two values would be different formulas.

Is there a lookup that can use the two week formulas to return values from the master data, using the name as well? I have tried vlookup and hlookup to no avail.

Thanks in advance