Formula to look up along with if/then

Occasional Visitor

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 "X" in a changes made column so I know what they have changed since I took a copy offline.  What would be the best formula to reference and employee ID(Column A), see if there is an "X" in the changes made(Column D) and depending on that changes made column either update column E or leave the data that's in it.  If there is an X in the changes made column I want it to pull the updated info into Column E, otherwise just leave what's there alone.  

 

Thanks

1 Reply

@Nate167 

=IF(D2="",E2,VLOOKUP(A2,sheet2!$A$2:$E$24,5,FALSE))

You can try an IF formula with VLOOKUP.

 

Sheet1:

sheet1.JPGSheet2:

sheet2.JPG