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.