Microsoft Excel Formula Help

Cancelled

Hello,

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.

Skills: Excel

See more: xls excel expert, need expert excel help, microsoft excel help, i need help with excel, formula it, expert in microsoft excel, expert in excel help, expert help with excel, be an expert in excel, uses for excel, microsoft spreadsheets, excel uses, excel help formula, need help with excel, need help excel, need a excel expert, i need to make excel projects, excel formula, excel match formula, need formula, microsoft excel worksheet problem solving, help solve, matching excel, need work excel, lookup excel

Project ID: #5362356

5 freelancers are bidding on average €14/hour for this job

hossionsumon

A proposal has not yet been provided

€15 EUR / hour
(89 Reviews)
6.2
priyal1997

Dear Sir I'm happy to help you on this task I'm an expert in advanced excel formulas You can visit my profile to see my reliability (5/5 >100 projects) I'm 100% sure that I can do this task within couple of hours w More

€15 EUR / hour
(80 Reviews)
5.8
caabdul

Salam! Let me take care of it. Kindly provide the file(s). There is no attachment. Thank you

€16 EUR / hour
(10 Reviews)
3.5
ceaserr

Hi, I have an experience of 5 years of working on excel and using excel formulas and I assure you of a perfect work Pulkit

€13 EUR / hour
(0 Reviews)
0.0
nbhatav

No skill can be developed without practice. It is this principle that we have kept in mind while designing our curriculum. We focus equally on training as well as practice. ABOUT NavDurga Services is focused to he More

€12 EUR / hour
(0 Reviews)
0.0
crucifige

Hello, I have solved your problem, please take a look at that; http://666kb.com/i/clbcla3p0v7vegmu7.gif By the way, the other #N/A values have been fixed as zero, too.

€16 EUR / hour
(0 Reviews)
0.0
davoodabbasi81

Im an excel exper and i can help you send me your file ............................................................ .............................................................

€12 EUR / hour
(0 Reviews)
0.0