IF Statement Excel
Posted on 2013-12-04
I would like to check to see whether the value in Cell A3 is present at all in the range of cells (A2:N24) on the Week1 worksheet as below.
However it always returns no because I think it is looking for the condition of that value being in every cell in that range?
Can someone please point me in the right direction on the right formula? I just want to confirm that the value present in cell A3 is in atleast one of the cells in range 'Week 1'!A2:N24'.