Conditional Vertical Lookup

  • Thread starter Thread starter soconfused
  • Start date Start date
S

soconfused

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.
 
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.
 
Back
Top