Two (Relatively) Simply Excel functions needed

  • Status Completed
  • Budget $30 - $250 USD
  • Total Bids 26

Project Description

Need help tweaking an Excel function to work with spreadsheet and coming up with an additional Excel function for same spreadsheet. This one should be quite simple and straightforward if you have sufficient experience with Excel functions (which I don't).

For the first function, I'm looking for a function that will compare the value in Column B for a row with all the values in the same column for the rows above as well as all the rows in that column (Column B) in two other worksheets and that will copy to Column A the contents of Column A for any match found.

For the second function, if the value in Column K matches a value in Column K on a different spreadsheet, the results will be copied to Columns M, P and Q.

Can send over sample spreadsheet to help explain things better.

Get free quotes for a project like this
Completed by:
Skills Required

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