Google Sheet Formula 2

Each day the “Report” sheet auto populates with new data. I need you to lookup data in column A of “Report” sheet and find in “Quickbooks” sheet column B. If found, copy the cell in Column G and display in “Sold” sheet.

*The “Quickbooks” sheet can have an indefinite amount of rows

*I am using Zapier and created a zap so that when a new row is added to the “Sold” sheet in removes my product from my Shopify website.

Skills: Accounting, C# Programming, Excel, Intuit QuickBooks, Software Architecture

See more: google sheets cell reference, google sheets formula builder, google sheets formulas sum, google sheets formulas cheat sheet, google sheets calculating formulas, google sheets array formula, google sheets formulas if, google spreadsheet formulas list, google sheet script print, database google sheet, excel macros convert google sheet, excel macros google sheet, google sheet help, update cell script google sheet, google sheet database, google sheet user interface, import mysql table google sheet, google sheet, excel sheet formula, Google Sheet Script

About the Employer:
( 13 reviews ) Kalamazoo, United States

Project ID: #18867574

Awarded to:


Hi, Thank you for the invitation. Cheers.

$20 USD in 1 day
(4 Reviews)

11 freelancers are bidding on average $26 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$50 USD in 1 day
(665 Reviews)

I can easily do what you are looking for. I am a professional Excel and Google sheet expert holding years of experience in utilizing advance level tools and functions of Excel and Google sheet.

$25 USD in 1 day
(151 Reviews)

i can do this. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox [login to view URL]

$25 USD in 0 days
(16 Reviews)

Hi sir, I have read your description and understood you requirement. Data nature can only be identified when sheet is infront. I can do this task. I'll use Google Script to check the queries and update on requiremen More

$50 USD in 1 day
(3 Reviews)

Hi there, I am Suresh from India. I saw your project requiring assitance on looking up cells on Google sheets. I can certainly be of help to you. I will complete the work within 15 mins for the budget. I have p More

$10 USD in 1 day
(2 Reviews)

Hello! I am Romanian freelancer  ready to work for you. I have read your project and I am interested in working with you. Please contact me for more details. I am an accountant, so I can help you

$25 USD in 5 days
(2 Reviews)

I am precise and accurate with the given work. I am also deadline driven and work hard to complete assignments in a timely manner. My dedication attention and organization contribute to my professionalism. I consistent More

$20 USD in 2 days
(0 Reviews)

Excel work knowledge and use of macros to achieve solution of such issues. Experience of such issues on company level

$15 USD in 1 day
(0 Reviews)

I am a CHARTERED ACCOUNTANTANCY student, working on Excel is like a daily affair for me. Also, I possess good command over excel formulas, ensuring the quality of work. Relevant Skills and Experience I have been under More

$20 USD in 1 day
(0 Reviews)

Hi sir I have more then two years exprience in this field.I can give you assurance that I can do it easily if give me [login to view URL] can hire me with out any doubt. I have strong knowledge on Google sheets I can easily so More

$25 USD in 7 days
(0 Reviews)