Posts by rcm2702

    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.