IF condition on whole L column

[~§-/¥\-Ê-K~]

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?

 

[IML]

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"

 

[~§-/¥\-Ê-K~]

works great, thx =)

 

[zoya25]

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

 

[Jonmo1]

Try Index and Match for that..

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

 

[zoya25]

That worked beautifully! Thank you

 

[Jonmo1]

You're welcome.