Automatically filled in form

Hello,

I am trying to find a solution to the following problem:

I have a form that needs to be filled in with many fields tied to a certain value.

For example if the name field is equal to John then the Phone number, adress, job, gender etc etc would have some fixed values.

I want to use validation to create a list of names and fixed fields should change depending on what name is chosen. This could be done by a large chain of IFs, but it is pretty difficult to update and when you will end up with 100+ criterias you will just get lost.

Is there any other way to get this done without using IF?

Thanks in advance!