I'm using Excel 2010 and I have two worksheets. Sheet A has a unique identifier column and other columns with values. Sheet B has a list of identifiers and other fields for which I'm using a
VLOOKUP formula to populate from the values in Sheet A.
Ideally, I would like to edit the values in place on Sheet B and have them update on Sheet A, but this doesn't seem possible - when I try it I just overwrite my
=VLOOKUP formula with raw data. Am I correct that there is no way to do this?
Alternatively, is there a trick to click through or somehow automatically jump from the cell containing the
VLOOKUP formula in Sheet B to the original cell in Sheet A?
My overall aim is to hold all raw values in Sheet A and only reference these from Sheet B without having to manually search Sheet A in order to update data.