Google Sheets COMPLEX Formula

$20-250 AUD

Completed

Posted

almost 6 years ago

$20-250 AUD

Paid on delivery

Hi Team, I need somebody to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [login to view URL] Here is the spreadsheet: [login to view URL] To get paid for this job 1. Apply for it with a message telling me you are working on the formula now. 2. Complete the formula so its working and share your working sheet back with me 3. I will check and pay you $50 AUD for this work I have plenty more work, if I am impressed with your work, I will continue to hire you ongoing. Thanks.

Data Processing

Excel

Mathematics

Project ID: 17303493

About the project

28 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@kishu0079

Hello , I found what was the problem there with your formulas , and I made simple change in your existing formula. Please check my file and copy that formula. Your formula was working absolutely right , but there was issue with formatting ,which I have solved out. If you want , you can check . and If you satisfy , we can work together in future. If it's correct , I don't need payment . This is the sheet which I have added. --> https://docs.google.com/spreadsheets/d/1XRmgxaP65uCbFOSkFFx3_-z4002FoFB7yV-8LhOdKrE/edit#gid=650833108

$20 AUD in 1 day

4.8

(4 reviews)

2.7

28 freelancers are bidding on average $68 AUD for this job

@semi786

Hi Sir/Madam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel. I will complete this work very soon. I will put formula as per requirements. I know many things in excel like Formulas (Countif, Sumif, Index match, Vlookup and offset etc.). Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786

$50 AUD in 0 day

5.0

(343 reviews)

7.9

@schoudhary1553

Hello, I can help with you in your project Google Sheets COMPLEX Formula . I have more than 5 years of experience in Data Processing, Excel, Mathematics . We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$200 AUD in 3 days

4.9

(312 reviews)

7.8

@Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "

$50 AUD in 3 days

4.9

(213 reviews)

6.8

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. PS: working on the formula. Best regards

$50 AUD in 2 days

5.0

(218 reviews)

6.9

@sevillajk01

hi! let me help you with your project. I'm working on it now, but I only have view access so can't really help a lot. thanks

$45 AUD in 3 days

5.0

(22 reviews)

4.3

@prasannjeetp

"I am working on the formula now." Hi, I have seen the video provided by you before bidding this project. I have got clue to get your work done. Please award me this task. I can do it. Thank you. Awaiting your response.

$50 AUD in 0 day

4.4

(45 reviews)

4.5

@vijayvizzu7

Hi i figured out the error and now VLOOKUP working fine.. please ping me if you want to see it. or you can make changes in your sheet too

$55 AUD in 3 days

5.0

(9 reviews)

3.9

@RAZAQ786

hi,sir/madam I am providing All types of Online and Offline Data Entry, Web Research Jobs. Whether you need an enthusiastic Virtual Assistant or Office Admin Support I'm very willing to work with you. I'm fully capable of providing reliable & great quality work. Inbox me your any query & I'll reply you promptly. After doing about 5 years of successful jobs here on diffrent, for me I feel safe in saying that I can be a part of your team. Deliverable: An On-time Delivery in a Proper Format Revisions Provided High Quality Deliverable 100% Confidentiality Money Back Guarantee thanks

$50 AUD in 1 day

5.0

(1 review)

3.2

@prakash1317

I’m working on formulas now - I can provide you my workings when you award the project. I’m experienced in similar projects & I’m confident to complete this work perfectly. Pls award the project to start from now. Thank you

$50 AUD in 2 days

4.8

(8 reviews)

3.3

@nishantha041

Hi, I’m working on your requirement.i’ll update you if i success with it. Thank you.

$50 AUD in 3 days

5.0

(4 reviews)

2.9

@salimmurshed1111

sir, you can check my review, expert in google apps script, and any type of formulation in google sheet..

$45 AUD in 3 days

5.0

(2 reviews)

1.7

@KASERP

Hey! I'm KASERP I have reviewed your complete job description. I have fully understood your requirements and I fulfill all the qualifications required for this project. Quality work is my Priority. Let’s discuss rest details over chat. THANKS Regards KASERP

$50 AUD in 3 days

0.0

(0 reviews)

0.0

@Charlydlm

I need an email address to send the file solved, added another function into it but I have no clue where to send it … my email is charlyglez85"at"hotmail

$55 AUD in 1 day

0.0

(0 reviews)

0.0

@vw7896214vw

I'm working on the formula right now. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

$55 AUD in 3 days

0.0

(0 reviews)

0.0

@ngc604

Hi there, If you're just trying to lookup the UPC from the second & third sheet of your workbook I can take care of that for you ASAP. All the best, Chris

$30 AUD in 1 day

0.0

(0 reviews)

0.0

@shilpideepgoel

RESOLVED. RESOLVED. I have successfully resolved the same and awaiting a confirmation from your end. Do let me know how you want me to share the same with you. Thanks.

$198 AUD in 1 day

0.0

(0 reviews)

0.0

@philiphogg8

Task Completed. I am happy to share my solution with you. I have used the Match function to resolve the lookup issue you have been experiencing. Message sent to you with the URL link to my solution. Regards Philip.

$30 AUD in 1 day