Here are the results of my query:

Sheet2:

A B C D
1 CustomerName Date Location No.
2 Customer1 7/6/2009 1A 1 - 8
3 Customer1 7/13/2009 1A 1
4 Customer1 7/15/2009 1A NA
5 Customer1 7/17/2009 1A 1-8

These results are on Sheet2. On Sheet1, I have something that looks like
this (the top row of A thru E and the side row of 1 thru 6 are supposed to
represent the Excel columns/rows):

Sheet1:

A B C D
1 1 2 3
2 A 8
3 B
4 C
5 D

I want the formula in Sheet1, Column B, Row2, to look at the query on Sheet2
for the matching Location (in this case, 1A), the most recent date
(7/17/2009) and show the number in Column D to the furthest right (in this
case it is 1-8 and I only want it to show the 8).

In the original query there are multiple locations (i.e., 1A, 2A, 3A, etc.,
and 1B, 2B, 3B, etc., and so forth).

I hope this is understandable. Thanks for your help.