Closed

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
2
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.

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.

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