Prev: sumproduct i think
Next: Thanks
From: confused on 5 Nov 2009 22:05
Is there a way to write an if statement to look at column b and have it
check column L with a YES if the name starts with OD?

thank you
From: Tom Hutchins on 5 Nov 2009 22:25
Maybe something like this (in L1):

=IF(LEFT(B1,2)="OD","YES","NO")

Hope this helps,

Hutch

"confused" wrote:

> Is there a way to write an if statement to look at column b and have it
> check column L with a YES if the name starts with OD?
>
> thank you
 | 
Pages: 1
Prev: sumproduct i think
Next: Thanks