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.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pt_lily" wrote in message
...
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.

On Mon, 4 Aug 2008 12:00:07 -0700, pt_lily
wrote:

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

Thank you so much! This works perfectly.

"Ron Rosenfeld" wrote:

On Mon, 4 Aug 2008 12:00:07 -0700, pt_lily
wrote:

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

On Mon, 4 Aug 2008 12:34:11 -0700, pt_lily
wrote:

Thank you so much! This works perfectly.

"Ron Rosenfeld" wrote:

On Mon, 4 Aug 2008 12:00:07 -0700, pt_lily
wrote:

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


Glad to help. Thanks for the feedback.

--ron