Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: IF condition on whole L column

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there any way to do an if condition on the whole of column L?

    something like IF(anything in column L="Yes","Yes","No")

    so if any of the cells in column L="Yes" then carry on with IF condition, anyway to do this?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-19 09:55, ~-/--K~ wrote:
    Is there any way to do an if condition on the whole of column L?

    something like IF(anything in column L="Yes","Yes","No")

    so if any of the cells in column L="Yes" then carry on with IF condition, anyway to do this?
    =IF(COUNTIF(L:L,"yes"),"yes","no")

    will work if you are looking for a cell that just contains "yes" and not "yes sir"


  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    works great, thx =)

  4. #4
    New Member
    Join Date
    Jan 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF condition on whole L column

    to build on that... is there any way to do something like what you see below?

    something like IF(anything in column L=today(),whatever is in that row in column C,"NA")

    so if row 23 in column L=today() then show whatever is in row 23 column C

  5. #5
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF condition on whole L column

    Try Index and Match for that..

    =INDEX(C:C,MATCH(TODAY(),L:L,0))
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

  6. #6
    New Member
    Join Date
    Jan 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF condition on whole L column

    That worked beautifully! Thank you

  7. #7
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    44,054
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)

    Default Re: IF condition on whole L column

    You're welcome.
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •