Hi, I have two excel worksheets as data tables. The first data table called ‘GoodsCodes’ contains codes that will be used to search the Excel worksheet (As seen in the first screenshot in column A)
What I want to do is use the values stored in Goods Codes, search NomenclatureInfo (data table of screenshot 2 worksheet) and then copy columns B-G which contains the goods code in column A. The output of this will be back into the first worksheets Column B ‘Description’.
ie. Find the goods code number in Column A like below.
Then I want to copy column B-G as shown below relevant to the correct column A.
These are then the result I would expect to pick up. (Note how I skipped one row as it contained a duplicate value ‘- - -’ in column F. I must do this in all cases if it appears.
I am new to this and any feedback is greatly appreciated. Thanks
NomenclatureScrape.zip (1.2 MB)