If Begins With - Not Working - Please Help

  • Thread starter Thread starter pt_lily
  • Start date Start date
P

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.
 
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.
Click to expand...


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