Hello all!
I have a master price list that has all my SKUs and Retails across multiple vendors. Each worksheet is titled with a different vendor as the sheet name. I am trying to update our inventory with the new retails, and need a function that can match the SKU and retail across all the vendors (some same items come from multiple vendors for different costs) to that of our master inventory sheet. I need the function to give me the maximum value of "Retail" for any SKUs that return multiple retails. I was attempting to use INDEX or VLOOKUP, but I feel I am just in way over my head. Any help at all would be greatly appreciated!
I have a master price list that has all my SKUs and Retails across multiple vendors. Each worksheet is titled with a different vendor as the sheet name. I am trying to update our inventory with the new retails, and need a function that can match the SKU and retail across all the vendors (some same items come from multiple vendors for different costs) to that of our master inventory sheet. I need the function to give me the maximum value of "Retail" for any SKUs that return multiple retails. I was attempting to use INDEX or VLOOKUP, but I feel I am just in way over my head. Any help at all would be greatly appreciated!
