cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShangKer
Helper I
Helper I

Select value from two list which is the same

Hi, i have would like to pull value from another list. My main list has a column name DIV/DEPT which is corresponding to the second list "Department". The DIV/DEPT and "Department" got the same value. In the department contains the details for the department. Is it possible to pull the department details when the value in DIV/DEPT is the same as "Department"? As attached are my sharepoint list.

Sharepoint1.PNG
List 1: Contains the value input by the user. Data type are single lines of text.
Sharepoint2.PNG
List 2 which is same as the one in list 1.

Sharepoint3.PNG
I would like to put the admin name to the list 1. I have tried to use lookup column but nothing shown. 
10 REPLIES 10

Ouh I see where my errors are now thanks.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Top Solution Authors
Top Kudoed Authors
Users online (64,038)