Setup Excel function to reference a value on another sheet by using an existing column value. It would take that refrenced value and post beside it in next column.
Example
You have following values on multiple sheets:
Sheet one
Col C Col D
ARZ blank
TB blank
ATL blank
Function would recognize all ARZ, TB, etc. on all sheets – then, to the column just to the right, reference a single sheet that holds a value as such:
Sheet 14
Col A Col B
ARZ 3
TB 17
ATL 6
End result: I can enter values (a single or 2 digit number) to sheet 14, column B. It would relate directly to column A. Then, every Col C on every other sheet would post Col B value (from sheet 14) to the column to the right of it on its respective sheet.
Sheet one
Col C Col D
ARZ 3
TB 17
ATL 6
I would send you Excel file, you would program this function then send it back to me.
File is attached.
Use PMB for comments or questions. I need this the quicker the better.
ID del proyecto: 159446
Información sobre el proyecto
2 propuestas
Proyecto remoto
Activo hace 17 años
¿Buscas ganar dinero?
Beneficios de presentar ofertas en Freelancer
Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos