Edit the original data when using Lookup

[Ramus_01]

Good Morning 

Im hoping this will make sense.

I have a form that when data is put into the first field, it then auto fills the other fields using Lookup()

Ive put this into the Initial Value section so that the data is editable, however to do this it seems that you can only edit the data and the add it to a new sheet, whenever I try to use the sheet the data is in the results never show 

Is there a way to show the related data from a field and have it edit the original data 

i hope that makes sense 

[Marc_Dillon]

Don't use a form. Just open a table view of all existing records, and search for that "first value", then select the record.

[Jas9000d]

I have ended up doing it this way, not exactly what I was after but at least it works. 

I tried making a script that looks up the updated data in sheet 2 finds it in sheet 1 and changes the data to match, it then updates the API. It all worked in theory but it just inconsistently fired but more often than not it didn't fire at all. I've spent the last week trying various different things to get it to work every.time but I think the onEdit and onChange triggers are a bit flakey 

Thanks for your help