I have a large worksheet ("All Journals Working Copy",) that list all of our items numbers and inventory related stats. Item numbers (Column A) are repeated as we have many warehouses. I have a second worksheet (Item Master Download) on the same spreadsheet (range named "data") that has two pieces of information for each item number that I need to bring over to the first worksheet. Each unique item number although may be repeated but has only one "description" and one "item group" from the "data" range on my second worksheet (Item Master Download). I am not able to do a regular VLookup because many of the item numbers are repeated (due to the same item number being listed separately for multiple warehouses). I am trying to bring the "description" from "Item Master Download" into column B on my "All Journals Working Copy". Every item number listed on "All Journals Working Copy" appear only once on the "Item Master Download".
How can I bring over the corresponding information from the second worksheet "data"? I hope I have provided enough information. Once I am able to do this I will then do a pivot table but I can't run the pivot table until I bring in the values need.
Bookmarks