Populating cells on one sheet with information from another sheet.

[ryanspecter]

Hi there, I receive monthly usage reports for the mobile phones at our organisation, these reports need "Cost Centre" codes inputting.

At the moment I have been doing this manually by searching the for the codes on our employee database for each individual "Team Name" and then manually entering them into Excel.

If possible I would like to use a sheet of these "Team Names" and their "Cost Codes" to automatically populate the usage reports with the cost code.

What is the easiest method of achieving this and what is the method?

Example document attached.

To Clarify I want to use the data highlighted in green on Sheet 2 to fill the column highlighted in red on Sheet 1

If it helps: The position of names in the Usage Reports will change frequently as there is frequent change to the staffing of the organisation and allocation of the devices, meaning one can't simply copy a column of the cost centres over to each new report.

[dosydos]

for this i would just utilize a vlookup formula. This looks at the Team name in the row on Sheet 1 and Finds that team name on Sheet 2 and relays back the corresponding Cost code.

In cell F2 on Sheet1 insert the following formula and copy down.

=VLOOKUP($E2,Sheet2!$A:$B,2,0)

[ryanspecter]

Does your version of the formula cover the entire range? Data set consists of 1100 users.

[dosydos]

the bold part in =VLOOKUP($E2,Sheet2!$A:$B,2,0) means that it will look through the entire Sheet 2column A for the Team Names. Meaning that you could have up to 1,048,576 names in column A and it will work.

[ryanspecter]

Fantastic, I tried the formula and it works exactly as I had envisioned, thank you for your help.

[dosydos]

Glad it works and thanks for the rep