Auto-populate one cell in a sheet from another cell in a sheet, with corresponding name
I have one sheet (A) that acts as a database of our customers. There are many customers in this database, including person (X).
I have another sheet (B), with it's own form. This form is filled in by our customers.
When person (X) completes the form for sheet (B), I want a column in sheet (A) to be marked 'Yes', but it has to correspond to person (X) in that sheet.
So I want it to automatically find person (X) in the 'Name' column of sheet (A), and put 'Yes' in the 'Form complete' column of sheet (A). Bear in mind that person (X) will have to input their name in sheet (B) (hopefully this is a good enough link to make it work).
If that makes sense... 😋
Help Article Resources
Check out the Formula Handbook template!