Microsoft Excel Formula Help

  • Status Completed
  • Budget $10 - $30 USD
  • Total Bids 17

Project Description

I need help with one Excel formula. Attached are spreadsheets 1 and 2.

I used the lookup function in Excel for this formula but it does not work correctly. I need an Excel expert I can go to for this and from time to time with potentially larger projects. An excel expert should be able to solve this in 5 mins or less.

The problem with the way I am doing this is that [url removed, login to view] uses the lookup function to lookup values in column F of [url removed, login to view] to match the F column in [url removed, login to view] with the date in 2.xls. If the date is not there in [url removed, login to view] it continues to add the same value from the previous cell instead of 0. I want it to add the value in column F of [url removed, login to view] in [url removed, login to view] with the matching date and if the date is not there, make it a 0 instead of the value from the previous cell.

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