Not at all
This formula should do the trick:Let me knowFormula:
=IF(NOT(ISERROR(MATCH($V$10,$G$6:$G$28,0))),"Week 1",IF(NOT(ISERROR(MATCH($V$10,$K$6:$K$28,0))),"Week 2",IF(NOT(ISERROR(MATCH($V$10,$O$6:$O$28,0))),"Week 3","Not Found")))![]()
Not at all
This formula should do the trick:Let me knowFormula:
=IF(NOT(ISERROR(MATCH($V$10,$G$6:$G$28,0))),"Week 1",IF(NOT(ISERROR(MATCH($V$10,$K$6:$K$28,0))),"Week 2",IF(NOT(ISERROR(MATCH($V$10,$O$6:$O$28,0))),"Week 3","Not Found")))![]()
Last edited by ajryan88; 03-04-2014 at 07:02 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks