Formula for pulling data

[p0l0levu]

Hi

I will try and make this as brief as possible.

1 workbook, 2 sheets. Sheet 1 has master listing (about 20K lines) and Sheet 2 has a listing with serial numbers and dates. They both have columns for item code but sheet 1 includes more items then Sheet 2 so I want a formula to look at the item codes in sheet 2, find the same item code in sheet 1, and transfer the serial numbers which are alphanumeric and with symbols (eg 10-35AID/10-14176)

I have tried SUMIF(SHEET2!A:A, A2, SHEET2!C:C), VLOOKUP, and even =INDEX(Sheet2!A:A,MATCH(A2,Sheet2!C:C,0))

Is it possible?

 

[RonB1111]

It would be helpful if you'd post a small amount of sample data along with your expected results. Your verbal description is confusing and contradicts the formulas listed. INDEX/MATCH is the way to go, but please show your data layout for a specific recommendation.

 

[p0l0levu]

It would be helpful if you'd post a small amount of sample data along with your expected results. Your verbal description is confusing and contradicts the formulas listed. INDEX/MATCH is the way to go, but please show your data layout for a specific recommendation.

Thanx never mind...managed to figure it out with the VLOOKUP formula