Google Sheets - Creating Lookup/Offset and Sum Formulas to be created

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

Hi, I need some formulas to be written in google sheets. The link is below; You can create a copy to edit it. [login to view URL] It is already written in the sheets, but here is what I need: 1) In summary tab: Lookup values from the Table indicated in column A, and get values via OFFSET function. This need to be done for coumn B,C,D,E 2)In Y&K tab: Lookup values in Table indicated with Y and K, sum values on the right of them for both "m2" and "mtul" Thanks,

Data Entry

Data Processing

Excel

Project ID: 18425021

About the project

9 proposals

Remote project

Active 5 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:

@SBITServices

Hello Derbay, I have checked the file and i can write lookup formulas for summary tab . I have 5 years experience in advanced concepts like Pivot table, Vlookup, Charts, Data analyser etc. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality With Regards, Sai

$20 USD in 1 day

4.9

(525 reviews)

7.8

9 freelancers are bidding on average $22 USD for this job

@AkhilWP

Hi there, I am on vacation, I am a Rocket Scientist,I can do this work very easily. Looking forward to hear from you.

$25 USD in 1 day

5.0

(6 reviews)

3.9

@mdzahedhossain

Hello, I am expert in a Data entry work. I already read your project details and my experience and expertise will make your project successful. I have excellent skills in all Microsoft Office packaged in particular Word and Excel and have good skills in spreadsheets. Hope my work accuracy will be 100% accurate. If you think I have capability to do your job you can contact me via massage. Regards, Zahed

$15 USD in 1 day

5.0

(9 reviews)

3.4

@ahmed912008

If you want i can give you sample I'm ready to deliver within 24 hours. Hello, I'm interested in your project. I have experience in Excel , word and power point.

$20 USD in 0 day

5.0

(3 reviews)

1.9

@Haardeek

Dear Hiring Manager

$10 USD in 1 day

5.0

(2 reviews)

0.4

@Krazzaq47

hi sir I have read your requirements and want to discuss this task with you. I have experience of this kind of task

$30 USD in 1 day

0.0

(0 reviews)

0.0

@P1anjali

I have experience of 2 years in Microsoft Excel and have automated many tasks using macros in excel.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@jsh199192381

hi, dear I have a good data processing skill and I have a full time. I am confident in processing the data with Excel or Word. If you hire me,I will do my best in this work. Please show me your project in detail. I'll wait for the good news. thanks.

$20 USD in 1 day