I am trying to write a functional statement that picks up a certain value on
a different worksheet.

If the first 4 letters of this column in this sheet equals this, insert H-
in this cell.
--
DMM

Possibly:-

=IF(LEFT(Sheet2!A1,4)="abcd","H","")

Mike

"soconfused" wrote:

I am trying to write a functional statement that picks up a certain value on
a different worksheet.

If the first 4 letters of this column in this sheet equals this, insert H-
in this cell.
--
DMM

Mike,

I don't think I posed my question properly.

I have two work sheets and the first column of the 2nd worksheet has all the
combinations of parts that I need. On the first sheet in column C are part
numbers. I have to look at the 2nd sheet to see what kind of part it is and
insert a single letter in the first worksheet in column C.
--
DMM


"Mike H" wrote:

Possibly:-

=IF(LEFT(Sheet2!A1,4)="abcd","H","")

Mike

"soconfused" wrote:

I am trying to write a functional statement that picks up a certain value on
a different worksheet.

If the first 4 letters of this column in this sheet equals this, insert H-
in this cell.
--
DMM