Salesforce Lookup Issues: Null Account Names and Missing Results

Hi there, I have a few different Salesforce Lookups in a table, that should 100% return a found result on the account level. However, it is not returning the result. In addition, where I did find a contact associated with the account, it is not showing the account name as a field to "draw out." It shows Null, which is not the case in Salesforce. I will place screenshots below this thread.