Importing Lookup Fields from Excel

[znpnh]

Hi!

I have a table that contains about 75 fields. Each field is going to be a Lookup field that will allow the user to enter multiple values. This is for a home inspection service. So the first field name will be ExteriorShingles. The user clicks the dropdown arrow, and is allowed to select multiple values such as "loose", "missing", "rotted" etc... I was wondering if there is an easy way to import all these values from my Excel spreadsheet, or do I have to enter each one individually, which is going to be a lot of work. Any shortcuts would help!!

Thanks!!

 

[CJ_London]

look at using the transfertext function to imprt or link to the spreadsheet. Here is a link to get you started

http://msdn.microsoft.com/en-us/library/office/ff844793(v=office.15).aspx

 

[znpnh]

Thanks much! I'll take a look at that in depth this week!!