Hi Guys,
This is my first time on this forum but I am struggling badly with a problem and I could really do with a helping hand;
I have two spreadsheets with data, for the purpose of an easy explanation spreadsheet A and B.
Within both spreadsheets is a column with a list of SKU's and a Column with a list of Prices. What i need to do is compare the SKU column in Spreadsheet A with the SKU column in Spreadsheet B. When the formula finds a match it copies the corresponding data from the price column in Spreadsheet A and populates the Price column in spreadsheet B.
I'm presuming it will be best to initially compile both sets of data as worksheets within a spreadsheet. I cant seem to find a formula that works so far (obviously my own user error!)
Any help would be truly appreciated, this stands to save me 2 or 3 weeks worth of work.
Many thanks in advance
Cory.
Bookmarks