I have two excel files one contains a list of car parts their part numbers, description but no prices and the other contains part number, price and description and in both files separated in their columns.
What I would like to achieve is to be able to merge and organise both spreadsheets so that the one without prices incorporates all the prices from the other sheet. I've been told I can use Vlookup, IF and ISNA functions to achieve this but I don't know how. And the descriptions all match up via concatenation and the spreadsheet ready to be uploaded to my store tab or comma delimited.
I need this done urgently please. I will send you the files if required. There are quite a few products in them. Happy bidding!