Copy data from one spreadsheet to another

[Davjel]

Hi
I have two spreadsheets one I upload to the cloud for the sales team to use. The other is an ODBE spreadsheet from sage.
I am hoping that the ODBE spreadsheet will update automatically from sage.

Is there a formula I can use to get the relevant data from the OBDE to the upload sheet. Such as stock quantity and prices

Both files are indexed on the product code but the ODBE file is likely not be constant as I add and remove codes.
Any help would be appreciated
David

[jasper90]

Is this a Vlookup candidate?

[Davjel]

Hi jasper90
Thank you for pointing me in that direction.
I have read up and watched a couple of tutorials. All I have to do now is put it into practice.
Regards
David