Microsoft Excel Formula Help

In Progress

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: #5362297

Awarded to:

subhashishkar

Hello, Thank you for the information provided. Your problem was very simple and I do not think that this is even worth you spending anything. To save both your time and money, I am adding the solution below. Use the More

$10 USD in 0 days
(0 Reviews)
0.0

15 freelancers are bidding on average $22 for this job

hossionsumon

Dear sir, I've extensive experience Can i any help Microsoft Excel Formula. My success always measure with client's satisfaction. So, i always try to do the best. Please let me know if you have any questions. More

$33 USD in 1 day
(89 Reviews)
6.2
nagybatonyi

I can provide the right formula in one hour. Fixing of bugs and minor changes are included in the bid without any additional fees.

$25 USD in 1 day
(48 Reviews)
5.6
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Woudl you like to discuss more?

$24 USD in 1 day
(88 Reviews)
5.6
MDavidCrompton

Hi, I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio More

$25 USD in 1 day
(23 Reviews)
4.9
SteveP495

Hi, [I HAVE YOUR SOLUTION...] I build robust, strategic business solutions period. We can get this sorted out straight away...(i.e. now if you want).. PEDIGREE / PREVIOUS WORK My pedigree includes these More

$30 USD in 0 days
(2 Reviews)
4.5
rengrish

I have excellent 10+years of experience in Excel/VBA. Please check my past reviews and ratings. I assure you 100% accurate & quality job. Just 5-10 mins i will be able to answer you . I am sincere,honest and hardw More

$25 USD in 1 day
(41 Reviews)
4.5
Virtualworker50

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

$25 USD in 1 day
(13 Reviews)
3.9
mirabueno319

I can do this for you. I am proficient in Microsoft Excel. I work fast and accurately. In one project I did, I combined data from 2 files, each having at least 180K entries. See my reviews. Message me so I can sho More

$15 USD in 0 days
(7 Reviews)
3.9
Royalflush1986

DONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDONEDO More

$20 USD in 1 day
(8 Reviews)
3.3
seanmdale

Hi DP Trade, Please check out my profile. I have worked with various organisations on small and complex Excel VBA developments. As a guesture of good will and to prove I am a competent professional you can trust, More

$10 USD in 1 day
(5 Reviews)
3.2
schungur

SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED IN A SECOND...SOLVED I More

$25 USD in 1 day
(1 Review)
2.1
moustafaa

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

$40 USD in 1 day
(2 Reviews)
1.9
rashidaliansari

A proposal has not yet been provided

$30 USD in 0 days
(1 Review)
1.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.

$20 USD in 0 days
(0 Reviews)
0.0
davoodabbasi81

Im an excel expert and its easy for me ................................................... ...................................................

$10 USD in 1 day
(0 Reviews)
0.0
mytym

I can do this for you no problem. I use Excel everyday and fixing formulae is my specialty. Let me know if you're interested.

$10 USD in 1 day
(0 Reviews)
0.0