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