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.