Hi,

I was wondering whether someone could give me some assistance with
linking a cell from one work sheet to another based on another cell in
both work sheets.

The linked cell I want is on the sheet (called partsand product
numbers) below (highlighted in yellow) and the if clause is highlighted
in blue:

Ok I can't put a print screen in!

So,

In column D: In Column E
200467880 8400
802k93580 8500/8550
685778500 8500/8550
d86959004 8400
673658590 8400/8500/8550


This continues for a long time...

The sheet (called Stock) I want to link it into is as follows:

In column A In Column D

200467880 ?
685778500
673658590
d86959004

and so on.

So, what I want is it to say ' if column a column in sheet titled stock
is equal to column d in sheet titled partsandproduct numbers, pull in
the corresponding cell from column e (including all punctuation and
values)


If any one could help with this I would be most grateful.

Many thanks,

Greg