Unmerge the cells, it's bad enough using merged cells in the first place but
if anyone feel they need to then it should be out away of any data and just
for fluff like the top rows or something. Btw, if you merge cells the upper
most left cell is the only one that can have any contents. However you need
to read up on how MATCH works, you need to use a 1x1 row/column range, what
would you expect your formula to return if there was a match, the row or the
column count? You are using A1:M34, that won't work. If you just want to
test a range if a value is in there you can use

=COUNTIF(A1:M34,E50)




--


Regards,


Peo Sjoblom

"robzrob" wrote in message
...
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?