I created Import to insert records into Main form and subform. it works just fine when subform has regular text fields.

However, it does not work if subform has "Lookup Filed".

Here is how I defined Lookup

 

AUDIBLE_US - Staff - Name
(App name - Form name - Field name)

 

And here is what I have on excel file (again, it works just fine with regular field and I know that I can select these values in my subform:

1st sheet:

PRODUCT ID	Narrator_SubForm
TEST3	1,2

 

2nd Sheet

REC LINK ID	NarratorSub
1	Alexander, Elijah
2	Alexander, Shoshana

 

here is the error:

 

Import Summary

Form Name	Total Records	Success Count	Failure Count
Narrator_SubForm 2 0 2
General info Hide Errors 1 0 1 Error details of records that could not be inserted Row 2 Col 3 - Value '1,2' is not an option in the field 'Narrator_SubForm'