Are you sure everything is formatted the same? In other words, in the array
you are looking in, are the dates considered actual dates? Or are they text?
If you think they might be text, you could try:
=MATCH(E50,--TEXT('SET-UP'!A1:M34,"mm/dd/yyyy"),0)
Enter as an array** formula (CTRL+Shift+Enter)

If you are still getting errors, describe how your data is formatted.

Hope this helps.
--
John C


"robzrob" wrote:

Trying to do a quite simple MATCH. In B53 I've got

=MATCH(E50,'SET-UP'!A1:M34,0)

E50 is a date, and there is a date exactly matching it in 'SET-UP'!
A1:M34', but it's coming up #N/A. Tried

=MATCH(E50:F50,'SET-UP'!A1:M34,0) where E50:F50 are the 2 merged cells
where the date to be matched is and get #VALUE!

Also tried

=MATCH(E50,'SET-UP'!A:M,0), still get #VALUE!

Is there a rule against referring to other worksheets in a MATCH?