help to create a work roster

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

Hi I need help to create a roster that pulls from data from a master roster.

for example:

will need to look up the technicians details by his employment number and the copy the entire row.

I have used the = and the cell and used the drag function but because the master roster row numbers always change when they add new people it then pull the wrong persons data into my new roster.

I was thinking maybe can use the Index and Match function?

Please assist

Ethan

Excel

Nº del proyecto: #18197639

Sobre el proyecto

5 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

keerthanakumar90

High level experience with Excel, Google Docs and Research while working as a data analyst for top firms such as Accenture and Ernst & Young. Over 3+ years of US experience along with a Master's Degree in Information M Más

$25 AUD en 1 día
(1 comentario)
1.0

5 freelancers están ofertando un promedio de $70 por este trabajo

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project create a work roster. I can assure you the quality job. I have good experience in Excel. We have worked on several similar projects before! Más

$100 AUD en 2 días
(384 comentarios)
8.2
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Más

$100 AUD en 3 días
(73 comentarios)
6.1
dataexplorer

"Hi Dear, I’m an efficient data entry worker. I’m familiar with Google docs spreadsheet and I’ve experienced about collecting data from websites and enter into Excel and Google docs spreadsheet. I would love to tell Más

$100 AUD en 1 día
(18 comentarios)
4.3
coolviper01

I can provide you what you need for I am a freelance data encoder. I have been in this business for 13 years.

$25 AUD en 1 día
(0 comentarios)
0.0