In Progress

Google spreadsheet script functions (2)

Very simple project...

I need two Google spreadsheet script functions that can be called from the cell of one worksheet to access data in the table of another sheet.

The script functions include...

1) Function – LookupRow(ColName, WorkSheetName, row)

a. Return the last value in the last row for a column by column name or column letter in given worksheet. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.

2) Function – LookupRowDate(ColName, WorkSheetName, date, row)

a. Return the value in the cell in a specific column for a specific row by date found in column A. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.

Sample data is provided in the attached file but will actually reside in a Google spreadsheet document. Please provide a sample of similar work so that I know that you can actually do this job.

Skills: C# Programming, Google App Engine, Javascript

See more: spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, spreadsheet google functions, spreadsheet functions google, script programming, script google spreadsheet, programming functions, job spreadsheet, job letter sample, google spreadsheet example, google programming, functions programming, functions in programming, function sheet sample, example of a job letter, example letter job, c sharp job, google spreadsheet valid data script, google script function, spreadsheet google, Google Sheet Script, google script spreadsheet, spreadsheet 2

About the Employer:
( 14 reviews ) Woodinville, United States

Project ID: #1127920

Awarded to:

AlexMDumitru

Please, check your PMB.

$200 USD in 2 days
(6 Reviews)
4.5

6 freelancers are bidding on average $183 for this job

sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$250 USD in 5 days
(17 Reviews)
5.7
richb38

Hi, I can get to this early next week.

$180 USD in 7 days
(1 Review)
2.4
manojdotnet

Hi, I am interested to work on this project . Please find more details in your PMB. Thanks, Manoj.

$200 USD in 7 days
(0 Reviews)
0.0
nkgautam77

Dear Sir, I have attached demo scripts... see details for PM

$170 USD in 4 days
(0 Reviews)
0.0
up2date

Sir this is vary simple problem . i can do this ,

$100 USD in 3 days
(0 Reviews)
0.0