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.
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 Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.