Cross-Sheet References with Contacts
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.