Automatically filled in form

**Xathrax** · 11-17-2010, 05:57 AM

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!

**royUK** · 11-17-2010, 06:06 AM

Without seeing an example workbooks I would suggest VLOOKUP

**Xathrax** · 11-17-2010, 06:25 AM

Here is an example of the form I made. If you highlight the field under Handling officer you can choose a name. If you do so 2 fields will be filled in.

I want to get the same results without using if because I will have 100+ people in the list