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.
List 1: Contains the value input by the user. Data type are single lines of text. List 2 which is same as the one in list 1.
I would like to put the admin name to the list 1. I have tried to use lookup column but nothing shown.