If Begins With - Not Working - Please Help

[pt_lily]

I have a column, H, that contains various product item numbers. I need the
column next to it to return certain values depending on the first two letters
in the item number in column H. I have tried the fomula below, but it only
returns blanks. My item numbers, for example, would read IN056242. If it
begins with IN, I need it return a Yes.

=IF(LEFT(H2)="IN*","Yes",IF(LEFT(H2)="NS*","No",""))

Any help with what I am doing wrong would be greatly appreciated.

 

[Don Guillett]

try it this way
=IF(LEFT(M5,2)="in","y",IF(LEFT(M5,2)="ns","n",""))

 

[Ron Rosenfeld]

I have a column, H, that contains various product item numbers. I need the
column next to it to return certain values depending on the first two letters
in the item number in column H. I have tried the fomula below, but it only
returns blanks. My item numbers, for example, would read IN056242. If it
begins with IN, I need it return a Yes.

=IF(LEFT(H2)="IN*","Yes",IF(LEFT(H2)="NS*","No",""))

Any help with what I am doing wrong would be greatly appreciated.

=IF(LEFT(H2,2)="IN","Yes",IF(LEFT(H2,2)="NS","No",""))
--ron

 

[pt_lily]

Thank you so much! This works perfectly.

=IF(LEFT(H2,2)="IN","Yes",IF(LEFT(H2,2)="NS","No",""))
--ron

 

[Ron Rosenfeld]

Thank you so much! This works perfectly.

Glad to help. Thanks for the feedback.

--ron