Microsoft Excel Formula Help
- Status Completed
- Budget $10 - $30 USD
- Total Bids 17
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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online