Excel SpreadSheet IF,Then formulas

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

DELIVERABLE: is to derive the difference between 1% NCDF [Column L] in Sheet "Payment2017" and " Amount in [login to view URL]" [Column E] in Sheet Remittance2017, using Vendor Name and Document Number of both sheets as the matching factors.

In my crude attempt, I have created a "NAOC Remit" Column M in Sheet "Payment2017" and I have been manually picking from "Remittance2017" to derive the Difference [Column N].

Please do not apply if you do not understand what I need you to do.

Here's a sample of the job.

Data Processing Excel Excel Macros Excel VBA Visual Basic

Project ID: #19849922

About the project

30 proposals Remote project Active 4 years ago

Awarded to:

bluesea1990

Hello. Welcome! I'm excited that you’re here! ✅ I have fully read the task, and assure that I can complete the task with no error. ☻My idea :" It proves that the best food is honest food, made to uncomplicated recip More

$30 USD in 7 days
(16 Reviews)
4.5
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$30 USD in 1 day
(396 Reviews)
7.0

30 freelancers are bidding on average $22 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$30 USD in 1 day
(370 Reviews)
8.0
MimiFL

Hello, this is definitely possible, but i need to ask few follow up question about connecting the two sheets. If you are interested in working with me, please message me so i can ask you few follow up questions. I am a More

$20 USD in 0 days
(560 Reviews)
7.1
priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I.m an expert in advanced excel skills and can do this task within few minutes. You can refer my profile to see details about me and my reliability, and if you are More

$25 USD in 0 days
(193 Reviews)
6.8
nvchien94

Hello there, I am an Excel expert and I have thounsand ways to complete this task for your. Formula or VBA/Macros is no problem with me. Please contact and you can get your result in 15 mins. Thanks

$20 USD in 1 day
(197 Reviews)
6.3
razvancotofana

Hello Diseph, I've already done a test on your file and I can send you the sample over chat to confirm that this is what you are looking for. BR, Razvan

$20 USD in 2 days
(18 Reviews)
6.0
sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer, currently at the post of Forum Expert at www.excelforum.com. I checked the attached sheet and can provide you both macro or form More

$15 USD in 1 day
(143 Reviews)
6.0
sevillajk01

hello! let me help you. I offer high quality and accurate output. Just award the project to me and I will take care of the rest. Hope you will consider me, thanks.

$20 USD in 7 days
(30 Reviews)
4.6
arash18k

Hi, since you have to criteria for finding the matched column in the second worksheet, so we have to use Macro to finding the related amount (Base on vendor name and document number). Also, if you think you can work wi More

$30 USD in 1 day
(13 Reviews)
4.7
Krish1019

Hi, I have gone through the attached excel and able to get your requirement. I can write a macro to get the difference between 2 columns only when doc number of both sheets are matching and print the value in N colu More

$20 USD in 0 days
(9 Reviews)
4.5
paulodayto08

Hi Good Day! A serious freelancer here. I know how to do it. Please message me for the file. I've done a lot of Reports and Templates using MS Excel. Please consider my bid. With my experience as a VBA Macro More

$15 USD in 0 days
(46 Reviews)
4.7
khaldalfalah

please chat with me to upload you the file after updated from me, to see together if Ok or not (I solved with another way). CV: I am software engineer, Holder of a degree in Faculty of Information Technology - Univers More

$30 USD in 2 days
(7 Reviews)
2.8
dvdalon

Quite easy to use a formula to match the Vendor Name and Document Number of the two sheets and perform the calculation. I can actually do it in 1 day, but I have some other appointments, so it will take a few more days More

$12 USD in 7 days
(1 Review)
1.6
rnaushad

I have a lot of experience in excel and advanced excel. The problem at hand can be solved using vlookup. Please assign this project to me and I shall share the solution in about an hour. Relevant Skills and Experience More

$20 USD in 1 day
(1 Review)
0.4
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$27 USD in 7 days
(0 Reviews)
0.0
JiangXiaoMei

Hi there! Thanks for posting the job. I've read your project description and understood what you need. I am highly skilled and experienced in vb and c++, excel so I believe that I can help you with this project. More

$20 USD in 2 days
(0 Reviews)
0.0
lealei0830

Hi! The type of job you're looking for excites me . If given a chance I am willing to work according to your schedule and instructions. I highly recommend myself for this job! Hope to hear from you soon.

$20 USD in 7 days
(0 Reviews)
0.0
aishbadiya

hi i have already completed what your requirement is, message me to discuss further, and I can straightaway send you the files.

$26 USD in 1 day
(0 Reviews)
0.0
DEdT

Solved and ready for delivery. Macros Job in Excel. The logical if statement has been applied to the document numbers, tested and working. I can deliver it when you are ready. I may go off line soon. Just accept bid an More

$35 USD in 1 day
(0 Reviews)
0.0
pouryasamir

Hello, worked for more than 5 years with excel and word and powerpoint make me very precise and fast with this software, In fact I do some of this job first and send it to you, if you'll like it then we do the contra More

$20 USD in 2 days
(0 Reviews)
0.0
SyedHamza016

Hey, I can do your work and can do for a long time because I need to work for my studies. I can do every work with great responsibility. I can do it better than others. It belongs to my group of studies. I will be your More

$18 USD in 7 days
(0 Reviews)
0.0