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.

Participate now!

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