today, I've got a rather hard task on my doorstep:
I have two lists, which are connected via one lookup field.
Now, I need to import values from an excel list into the first list with the lookup field.
At this moment, an Id of the lookup value is needed, which I can't provide, because I only have the text value. The text values are already within the second list.
My problem is, that I cannot import value 2 into list 1, because I'm missing the Id of the value.
Is there any chance to make this import work?