I want to do the following:
1) I want the ID (Column A) for each product on 'wc-product-export-2017-07-28' to link with the correct part code (column C) on 'Armorgard Price List'. This is identified on the 'wc' sheet at the start of column D where i concatanated the code and description... maybe need to break this apart?
2) I then want the correct 'NLS Price' (Column L) on Armorgard sheet to show in the 'Regular Price' (Column Y) on the 'wc' sheet.
Guess this all on lookup codes, but appears to be loads of different types... also dont know how to break up a concatanate, when the formula is no longer there...
Please bear in mind that 'wc-product-export-2017-07-28' is for a csv import. if we add a lookup formula to this will this mean it cant import?
Also when i sorted the columns, not all the data was moving on the 'Armorgard' sheet.... is this normal, and if so, just be aware of this :-)!!
Also looks as though as if i can only upload one file... any ideas??
Solved by Z. S. in 11 mins