Is there any way to have users enter a unique ID number in a column in list A, have it reference list B (which contains data about them) to pull their information such as name, city, state, etc...? This would then populate columns in list A with the corresponding fields.

1 Answer 1


If I understood your question correctly. You need to create a lookup column in list B and refer it with the column from list A(in your case you need to refer ID from list A). While creating lookup column, you can choose what information you want to present from List A.

Here is an example: Link


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.