Altering data found through a lookup

[lynxbci]

Hi,
I have a list of data approx 9000 lines long (32 columns), and have a seperate sheet that allows a user to input a code. This then retrieves their data item using vlookup(). I would like to let the user then amend the contents of one of the fields, thus updating the original data list. Is this possible?

thanks

 

[Andrew Poulsom]

Hi Andrew,

Once you've updated the Lookup table, dont you have to re-instate the formula in the changed cell in H2:I2, or am I misunderstanding?

I assumed that the lookup formula was in another cell, eg B2. But I may be wrong.