=MATCH(A2,'Sheet1'!A1:N109,0)-1

no need to do ctl-shift-enter. Just enter


"Kevin Rodriguez" wrote:

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.