Trying to update values from one sheet to another.

  • I am using a VLookup to find a part number and a quantity. I would like to be able to change the quantity and have it changed in the original VLookup Range.


    My Example:


    Sheet 1: In cell A1 the value returned from the VLookup are part number "1172". The value in cell B1 is the quantity of "4".


    Sheet 2 contains the range that is supplying the part number and quantity values for the VLookup


    I need a way to change the Vlookup return (Quantity) and then update the original range located in Sheet 2.



    Thanks for your assistance.

  • Hello and Welcome to the Forum ...:smile:


    Attaching your file would make things a lot easier ... :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!