Microsoft Excel function formula

This project was awarded to hiratariq for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $100 USD
Total Bids
Project Description

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.


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
TB 17

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
TB 17

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online