In InfoPath, use a drop down list so when you make your choice another field is populated automatically. For example: I choose my name, automatically another field reflects my manager’s name I choose a name, another field displays a number, … Continue reading Using SharePoint list in InfoPath drop down like an Excel vlookup