I'm having an issues pulling lookup columns from List A and displaying them in List B.
List A has manufacturing sites with columns including the site name(Title), Site Region, Site ID, and Site Lead.
List B has its own columns along with some of the columns from List A. I create a new lookup column with the "Site (Title)" and check the Site Region, Site ID, and Site Lead columns checkbox in the List B SharePoint designer "Edit Columns" page. However, Only the Site (Title) and Site Region columns display data in List B, the other 2 (Site ID and Lead) show blank when they have values that show in List A.
I even tried creating a plain text version of the "Lead" address book lookup column and it's still showing up blank (and yes the sites in list B do have values for Lead and Site ID in list A). What seems to be the issue here?