lookup/match/if/index can anyone help me please?

[Gregula]

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)

In addition to this I have tried the following formulas, which do not work:

=INDEX('Parts&Product Numbers'!$E$3:$E$1000,MATCH(Stock!A5,'Parts&Product Numbers'!$D$3:$D$1000,0))

=INDEX('Parts&Product Numbers'!$D$3:$D$1000,MATCH(Stock!A5,'Parts&Product Numbers'!$E$3:$E$1000,0))

=VLOOKUP(A20,'Parts&Product Numbers'!D$3:E$142,2,0)



If any one could help with this I would be most grateful. I would really be willing to send you my workbook so you can see if you can get it to work! Thankyou.

Many thanks,

Greg

[starguy]

your third formula should work, add dollar sign before column number. formula should like this:

=VLOOKUP(A20,'Parts&Product Numbers'!$D$3:$E$142,2,0)

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)

In addition to this I have tried the following formulas, which do not work:

=INDEX('Parts&Product Numbers'!$E$3:$E$1000,MATCH(Stock!A5,'Parts&Product Numbers'!$D$3:$D$1000,0))

=INDEX('Parts&Product Numbers'!$D$3:$D$1000,MATCH(Stock!A5,'Parts&Product Numbers'!$E$3:$E$1000,0))

=VLOOKUP(A20,'Parts&Product Numbers'!D$3:E$142,2,0)



If any one could help with this I would be most grateful. I would really be willing to send you my workbook so you can see if you can get it to work! Thankyou.

Many thanks,

Greg

[Gregula]

I have done what you suggested but it still doesn't work. I would be willing to send you the sheet so you can see what I mean? I can't upload here as it wont accept 502kb!

[starguy]

ok send me file.
>>starguy_pak@hotmail.com

I have done what you suggested but it still doesn't work. I would be willing to send you the sheet so you can see what I mean? I can't upload here as it wont accept 502kb!