Hi all
I have a problem which i just cant seem to get my head around.
I have 13 sheets (12 months and a summary sheet) and a list of names down the left hand side for users.
I'd like to lookup in any of the columns on alternate monthly sheets (e.g. January, March, May etc), if the term "NC" exists. and if it does on the summary sheet in the column where i am placing my formula id like to display "yes" or something like.
So my formula so far is:
=IF(ISNA(MATCH("NC",'January 2016'!H2,0)),"","Yes")
which works great for looking up the H2 cell on the January sheet but how can i make it match against the H2 cell on every other monthly sheet? I've tried so many different ways im just so confused now. ha. I understand that to make it do every other sheet that i'll probably end up with a very cumbersome formula.
Any help would be appreciated, maybe i shouldn't even be using Match at all?
Thanks very much
Danny
I have a problem which i just cant seem to get my head around.
I have 13 sheets (12 months and a summary sheet) and a list of names down the left hand side for users.
I'd like to lookup in any of the columns on alternate monthly sheets (e.g. January, March, May etc), if the term "NC" exists. and if it does on the summary sheet in the column where i am placing my formula id like to display "yes" or something like.
So my formula so far is:
=IF(ISNA(MATCH("NC",'January 2016'!H2,0)),"","Yes")
which works great for looking up the H2 cell on the January sheet but how can i make it match against the H2 cell on every other monthly sheet? I've tried so many different ways im just so confused now. ha. I understand that to make it do every other sheet that i'll probably end up with a very cumbersome formula.
Any help would be appreciated, maybe i shouldn't even be using Match at all?
Thanks very much
Danny