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.
15 freelancers are bidding on average $22 for this job
Respected Sir, It is pleasure for me to render my services to you for fixing lookup formula in given two excel sheets. I assure you the quality and timely work. waiting for your positive response thanks Imran
Dear Sir, I am a senior Engineer and i am willing to help you in making the formula in your excel file work properly. Looking forward to work with you. Best Regards, Moustafa
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.