Cell referencing two worksheets based on a name or location

Hi Guys

I have a workbook with two worksheets. One contains Customer order data and the other contains customer agent details. The Customer Order data worksheet is pulled from elsewhere therefore I wanted to create an empty shell if there is such a thing. This shell will allow the user to be able to automatically populate the customer order data sheet with the details of the customer care agent once pasted into the workbook.

N.B Please note that the first worksheet will always be empty and the idea is that once data has been pulled into the workbook then the formulas will become active. The details in the Customer Care worksheet are just an example as this worksheet will always be empty.

I dont know what the best formula is in order to do this . Its just that I do not want the spreadsheet to return incorrect contact details!

Please find the workbook attached below.

Customer Database Mock.xlsx

in G4

=IFERROR(VLOOKUP($E4,'Customer Agent List '!$A$4:$C$9,2,),"")

in H4

=IFERROR(VLOOKUP($E4,'Customer Agent List '!$A$4:$C$9,3,),"")


Copy down in both cases