I could really use your help, I need to append data from once tab within a workbook to another. Each tab contains a separate database with a unique set of data. The goal is to reference/look up a certain information (Existing Database) and populate the first three columns in the (Master List to Update) with the corresponding data already existing within the (Existing Data Base).
I have tried a Look Up Formula, see below. It did return information from the correct reference column DEA in the Existing DB and deposited it in the (Master List to Update) This issue is when I check the result against the coresponding facility from which it should have been referenced, it does not match up, also see attached example.


=LOOKUP(E:E,'Existing Database'!E:E,'Existing Database'!D:D) - see Column A in The Master List to Update attached.

Any help is greatly appreciated.

Dan

Sample Data Append File 9.6.xlsx