help with index/match or lookup

I'm sorry, what i mean is get the value of the cell in sheet 2 grand total.

ex. im at sheet 1 i'll do a search using the date and name on sheet 1 to sheet two and get the value in the grand total column. like 8/1/2013 and cust A. then get the value on sheet 2 which is 4

Here's your finished example, with explanation.

Attachment 261758