Đã hoàn thành

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.

Kĩ năng: Kế toán, Lập trình C#, Excel, Intuit QuickBooks, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 13 nhận xét ) Kalamazoo, United States

ID dự án: #18867574

Được trao cho:

SamerHany

Hi, Thank you for the invitation. Cheers.

$20 USD trong 1 ngày
(4 Đánh Giá)
1.4

11 freelancer đang chào giá trung bình $26 cho công việc này

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( Thêm

$50 USD trong 1 ngày
(665 Nhận xét)
8.4
daniyal3214

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 trong 1 ngày
(151 Nhận xét)
6.2
haleem0786

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 trong 0 ngày
(16 Nhận xét)
3.6
Apisylux

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 Thêm

$50 USD trong 1 ngày
(3 Nhận xét)
3.3
SureshXobos

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 Thêm

$10 USD trong 1 ngày
(2 Nhận xét)
0.3
alinutza85

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 trong 5 ngày
(2 Nhận xét)
0.2
brainOmind

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 Thêm

$20 USD trong 2 ngày
(0 Nhận xét)
0.0
deepak1808

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

$15 USD trong 1 ngày
(0 Nhận xét)
0.0
abhibhatias

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 Thêm

$20 USD trong 1 ngày
(0 Nhận xét)
0.0
Surajitdhua

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 Thêm

$25 USD trong 7 ngày
(0 Nhận xét)
0.0