On Aug 7, 10:35*pm, John C <johnc@stateofdenial wrote:
Nevermind that. Your array, specified by 'SET-UP'!A1:M34, can only be one row
or one column. MATCH gives you the relative position of your lookup value in
that row or column, but multiple rows or multiple columns, it will give you
an error.
--
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?- Hide quoted text -

- Show quoted text -

Thanks, All, for the advice. Luckily my match values are in one
column so I can amend the array and go ahead.