Conditional Vertical Lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

soconfused - 12 Feb 2008 19:21 GMT

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.

Signature

DMM

Reply to this Message

Mike H - 12 Feb 2008 19:25 GMT

Possibly:-

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

Mike

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

Reply to this Message

soconfused - 12 Feb 2008 19:43 GMT

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.

Signature

DMM

> Possibly:-
>
[quoted text clipped - 7 lines]
> > If the first 4 letters of this column in this sheet equals this, insert H-
> > in this cell.

Reply to this Message