It hasn't quite worked, it is only pulling in the 8500/8550s, not any
of the other options.

Any other ideas?

Naveen wrote:
Try this
+----------------------------------------+
=VLOOKUP(A1,Sheet1!$A$2:$B$6,2,0)
+----------------------------------------+

where ...
- "Sheet1" is your first sheet
- A2:B6 contains master data

Please rate me.


"Greg" wrote:

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