2
I have a table in Google Drive and I want to use Scripts to do what I want to stay in a more dynamic way.
On Page2, I have the fields "Result" "Delay" and "Arrival" with their due results filled below, I want to create on Page1 in a field, a select that consult on Page2, in the Result, Delay and Arrival fields and show me the records registered on Page2, in the column next to where it selects the field (in case the results should come in column B1 and the term sought is in column A1 with the select’s section).
Friend, I enter this code where? I don’t know Excel, I’m trying to figure out how to do it, asked me and I think I can... Thanks from now on!!
– CRAJ
I do not only want the data, I want it to be a select that has the RESULT/DELAY/ARRIVAL fields in field A1 and that the data recorded below RESULT/DELAY/ARRIVAL appear in field B1 next
– CRAJ
Got it wrong. BTW Google Drive is quite different from Excel. I will edit my answer.
– Gustavo Rodrigues
Dude, I tried several ways...what would it be like to save the list items? I couldn’t do no, I just got "#ERROR!" when I play the code "=LOOKUP($A$1, Page 2! $A$1:$B$1, Page 2! $A2:$B2)"
– CRAJ
The version of Google Docs you are using in this function? It is the updated version (New Google Spreadsheets)?
– Gustavo Rodrigues