I have an excel template that will be used to import list items into SharePoint. One column in SharePoint is a multi-value Lookup column. I’m having trouble importing multiple values from excel into the lookup column in Sharepoint.
Example in excel: Japan, Brazil
Need this to import into a multi-value lookup column in SharePoint, but am running into issues when I tried a few different ways I found online.
Any help is greatly appreciated
Thanks
2