What I wanted to add to this is that in my case I imported some older data. Some of the lookup data in the Excel spreadsheet was not in the lookup table in my solution, so I still had a bunch of failures (about 15%). It took me a minute to figure that out. Once I did, it wasn't a big deal (for us anyway) to just substitute a valid lookup value.