Multiple Lookups and SumIf

Hi,

I have an excel sheet with three sheets.

Main Page- This sheet is where the formulas needs to be. It will have Names,Dates and the cells where we need to do a lookup.

Dump- This is the placeholder for the data. I need to fetch data from this sheet for the corresponding date and name with the main page. All is well till here.

But the problem comes in the Names being displayed in the Main Page and the Dump Sheet. The Names are not same.It is shortened in the main page.
For example

Main Page might have name as Russ. There will be no reference to Russ in Dump Sheet. It will have names like Russel Peters, Russel Mccabe etc...

I need to do a match for this.

To help in this matching, there is a sheet called as Reference. It provides the mapping between the names in Main page and Dump sheet.

So I need a formula which takes the name in the Main Page, gets the corresponding name in the dump sheet and does a match based on date for that name.

I have attached the XLS too.

I need this mainly in Google docs but if this is not possible in google docs i am ok with excel too.

Can someone please help me on this.