Altering data that was called with LOOKUP

[Lynxbci3]

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

 

[Dave Peterson]

It could be possible, but you may find it easier to just use:
Data|Form
from the data list worksheet.

Data|Form supports 32 fields.

If you need more, you may want to look at John Walkenbach's enhanced dataform:
http://j-walk.com/ss/dataform/index.htm
may be sufficient

And if you want to create your own, then Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html