Dannybpool
New Member
- Joined
- Apr 3, 2023
- Messages
- 3
- Office Version
- 2007
- Platform
- Windows
Hi all.
I have 2 spreadsheets.
Spreadsheet 1
Sku
OE part number
Blank (Cross reference number )
Spreadsheet 2
OE number
Cross reference number
What is best way to match the OE number and then copy the cross reference number from sheet 2 into the Blank field on sheet 1?
Basically we have on our stock spreadsheet an SKU and OE number populated but need to populate a cross reference column, we have from a supplier a spreadsheet which has an OE column and a cross reference column so need to pull the data to our sheet
I have 2 spreadsheets.
Spreadsheet 1
Sku
OE part number
Blank (Cross reference number )
Spreadsheet 2
OE number
Cross reference number
What is best way to match the OE number and then copy the cross reference number from sheet 2 into the Blank field on sheet 1?
Basically we have on our stock spreadsheet an SKU and OE number populated but need to populate a cross reference column, we have from a supplier a spreadsheet which has an OE column and a cross reference column so need to pull the data to our sheet