I have two lists filled with data (listA and listB). A is a list of people with column 'DepartmentName' in it. B is a list of departments with columns 'DepartmentName' and 'Building'.
I want to create a column 'Building' in listA and auto-populate it based on 'DepartmentName' (when it matches in A and B) using data from column 'Building' in listB.
(I'd have a list of people with their departments and their buildings in A).
It would be enough for me to simply display the additional 'Building' column in listA.
I've tried using lookup column but it seems like I have to use it while creating an item (I need to display the additional column for already existing data). It also seems like there's no way of creating a condition in calculated column that would resolve my problem.
Is there any way I could do this?
Best Regards,
Ania