I posted this topic before but no responses seemed to help. I will try a different approach to it.
Below are the values that need to be imported into the next sheet (picture2) referenced through UPC.
[Blocked Image: http://www.zuko.org/uploader/./userfiles/zuko/gib1.jpg]
[Blocked Image: http://www.zuko.org/uploader/./userfiles/zuko/gib2.jpg]
I need to be able to do this for multiple workbooks therefore needs to be written in VBA and ran by the macro. Is it possible to put the data into an array and use vlookup to return only the result of the vlookup into the sheet (picture 2).
It is really difficult to explain this in text, so if anyone needs more clarification, please let me know. Thank you all in advance.