Formula in cell A2 [=HLOOKUP(A1,'Dates'!C33:P33,'Dates'!34)] result = #NA
I am trying to read from a row in a sheet called 'Dates' cells C33 to P33 and return a value from 'Dates' cells C34 to P34 where the match is found. Row 33 has Days, Row 34 has corresponding dates.
The sheet I am entering the formula into is at cell A2. A1 contains Sunday (B1Monday, C1 Tuesday etc)
The formula should identify the same day in 'Dates' and return the date into cell A2. Result =#NA.
Can anyone advise please.
Bookmarks