I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different sheet that contains the name, email, and office code for each person. I think I need either use the VLOOKUP or INDEX formula but not sure what the actual formula language would be to get it to work.
Any help would be greatly appreciated.
Thank you,
Chris Hockey