Hello everyone! help me out with a problem I am stuck with.
So basically, I have a master table where I have general information about the people such as their gender, age, etc (each row for each person’s information). Now I have made a separate table for each person on different pages.
Any idea about formulas I can use to match the name of the specific person on the first table with the second table and then derive all the information such as the gender, age, etc on the second table. Note that I need a way that can show the change in information in the second table automatically if i make changes in information in the first table.
To understand my problem better, I have attached the layout of my tables as well. Waiting for your response. Thank you!