Help with matching numbers on separate worksheets

[coatesy69]

Hi all.
If there is anyone out there who can help me it will be much appreciated.
I'm still learning Excel and can't figure out if what I want to do is even possible.
It is to do with matching up numbers from two different Worksheets.
I have put a description in the attached document of what I am trying to accomplish.
It will be easier for you to look at that to get a better understanding of what I am after.

Thanks for any help.

Graham

[protonLeah]

sheet1 D4:

Please Login or Register  to view this content.

[coatesy69]

Thank you very much for that Ben.
Is it not possible to have the Vendor code automatically fill Cell D after the Item Number is entered in Cell C and tab is pressed.

Thanks again.

Graham

[AliGW]

Graham - that is what Ben's formula does. As soon as you have entered the number in column C, the corresponding vendor code appears in D.

[JohnTopley]

Change the range of the formula supplied by Ben (to match your likely manifest).

=IFERROR(INDEX(Sheet2!$A$4:$C$2000,MATCH(C4,Sheet2!$A$4:$A$2000,0),2),"")

When the Item Number is entered in C the Vendor WILL automatically appear in D if the data is in Sheet2.

[coatesy69]

Thanks John. I amended it and it now works great.
You two have saved me a lot of time

Graham