see if these ideas help

Sub findem()
x = Range("a12:e21").Find(1111).Offset(-1)
MsgBox x
End Sub
Function fd(x, y)
fd = Range(x).Find(y).Offset(-1)
End Function

--
Don Guillett
SalesAid Software

"Kevin Rodriguez" wrote in
message ...
I'm trying to find a value within an array, and then offset to a cell
above
the found cell to get a date.

To do this, I'm starting by trying to MATCH a value within an array and
getting an #N/A response.

My formula is:
=MATCH(A2,'Sheet1'!A1:N109,0)

A2, the value I'm trying to find, is on Sheet2. The array is
'Sheet1'!A1:N109. I committed by Ctrl-Shift-ENTER. Once I can get this
to
work, I'll have no problem with the rest.