Can I lookup a person in a table based on a people picker drop down?

Any ideas?

person or group field works like a lookup field.

so you can query its value by a sharepoint user ID like

lookup('Employees','Employee',EmployeeUserID,'Team',false,'Lookup')‍‍

or by sharepoint user Display name like

lookup('Employees','Employee',EmployeeDisplayName,'Team')‍‍

the main problem here is that people or group form control doesn't resolve to either of these two values, so you can not directly use it as an input to lookup() function.

if you have running profile services, you could use userProfileLookup() function to get (eg) employee display name.

if you do not, you will have to find other way how to determine one of these values, but it will need additional javascript code.

‌ ‌ ‌ ‌

Thank you for your reply.  Would you, or anyone, happen to have java code so I can input a name via a peoplepicker, and lookup that name in a list (Employees), so I can reference associated data such as team, role, etc?

if you have only single entry in PP field you can get selected user's display name with following code

NWF$('#' + jsvarPP).siblings('.ip-item').find('.ip-item-content').text();‍

so you can wrap it into a function and then reference the function in your lookup