Update numerous part prices from multiple price sheets with respective price breaks

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3175614%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EUpdate%20numerous%20part%20prices%20from%20multiple%20price%20sheets%20with%20respective%20price%20breaks%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3175614%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3ENeed%20to%20update%20each%20customer's%20mixed%20part%20numbers%20with%204%20price%20breaks%20(1%2C000%3B%205%2C000%3B%2010%2C000%3B%2025%2C000)%20using%20recently%20updated%20workbook%20containing%2030%20price%20sheets%20with%20same%204%20price%20breaks.%26nbsp%3B%20Is%20it%20possible%20to%20Vlookup%20a%20part%20number%20and%20price%20break%20through%20each%20of%20the%20respective%20sheets%20matching%20that%20part%20number%20and%20price%20break.%20Sort%20of%20the%20on%20the%20premise%20when%20using%20the%20%22Find%22%2C%26nbsp%3B%20%22Within%22%26nbsp%3B%20Workbook.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3175614%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3175614%22%20slang%3D%22en-US%22%3EUpdate%20numerous%20part%20prices%20from%20multiple%20price%20sheets%20with%20respective%20price%20breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3175614%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20to%20update%20each%20customer's%20mixed%20part%20numbers%20with%204%20price%20breaks%20(1%2C000%3B%205%2C000%3B%2010%2C000%3B%2025%2C000)%20using%20recently%20updated%20workbook%20containing%2030%20price%20sheets%20with%20same%204%20price%20breaks.%26nbsp%3B%20Is%20it%20possible%20to%20Vlookup%20a%20part%20number%20and%20price%20break%20through%20each%20of%20the%20respective%20sheets%20matching%20that%20part%20number%20and%20price%20break.%20Sort%20of%20the%20on%20the%20premise%20when%20using%20the%20%22Find%22%2C%26nbsp%3B%20%22Within%22%26nbsp%3B%20Workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3175614%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Need to update each customer's mixed part numbers with 4 price breaks (1,000; 5,000; 10,000; 25,000) using recently updated workbook containing 30 price sheets with same 4 price breaks.  Is it possible to Vlookup a part number and price break through each of the respective sheets matching that part number and price break. Sort of the on the premise when using the "Find",  "Within"  Workbook.

 

0 Replies