I'm trying to create a form in which I have a data validation drop down box. What I would like to have happen is, a selection from that list would trigger filling in information from a separate tab associated with the workbook. For example, the drop down list is "Clients". Selecting a specific client's name would trigger filling in client contact, address, phone, etc. in separate section of the form. I thought about using the "IF" function but I believe that function is limited to seven (7) entries. Thanks in advance for your help.