Formula to look up along with if/then

I'm working to merge two excel files into one, on is an offline file I've been making changes in and the other is a live file a team uses.  Since I broke off my offline file I've had this team put an...