Thanks:  0
Likes:  0

# Thread: IF condition on whole L column

1. 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. 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. works great, thx =)

4. ## 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. ## Re: IF condition on whole L column

Try Index and Match for that..

=INDEX(C:C,MATCH(TODAY(),L:L,0))

6. ## Re: IF condition on whole L column

That worked beautifully! Thank you

7. ## Re: IF condition on whole L column

You're welcome.

## User Tag List

#### Posting Permissions

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