Only looking up specific row to edit
I have a list of 500 staff members with contact details. If one of my staff changes their phone number, is there a way to lookup the staff member's row and change the values of one of the columns (in this case Phone Number), but could be any other 30 columns.
Basically some sort of form: type name > details come up and change what needs to be changed. without having to search through 500 entries.
Vlookup of the name can return the values in the columns, but I can't update the values to reflect the change.