Problem: After downloading a view as a .csv, some of the content within a lookup column is being replaced with #name-quiz-app

Below is the content as it appears within Airtable.

After downloading this view as a .csv, below is how it populates. In column C, the content was replaced by #NAME?.

Any idea as to why this is happening? This is a huge dealbreaker for our team affecting our decision to purchase Airtable.