8 deleted 37 characters in body; edited tags
source | link

How do I get data from one Google SpreadsheetSpreadsheets "A" into SpreadsheetSpreadsheets "B"?

How do I get data from one Google spreadsheet A into spreadsheet B? so
And whenwhen Spreadsheet A is modified, then Spreadsheet B also changes automatically.?

A formula using QUERY() and IMPORTRANGE() functions was tried, but it didn't return the expected results.

UPDATE:

For example:

, I have two spreadsheets Documents DocA and DocB:

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

uid serial_no in Cell B2 instead of the value in Cell A2 of DocA.

How do I get data from one Google Spreadsheet "A" into Spreadsheet "B"?

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically. A formula using QUERY() and IMPORTRANGE() functions was tried, but it didn't return the expected results.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

How do I get data from one Google Spreadsheets "A" into Spreadsheets "B"?

How do I get data from one Google spreadsheet A into spreadsheet B so
when Spreadsheet A is modified, then Spreadsheet B also changes automatically?

A formula using QUERY() and IMPORTRANGE() functions was tried, but it didn't return the expected results. For example, I have two spreadsheets Documents DocA and DocB:

    A               B           C
1    uid            serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get uid serial_no in Cell B2 instead of the value in Cell A2 of DocA.

7 Reworded the first part of the question.
source | link

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically. A formula using QUERY() and IMPORTRANGE() functions was tried, but it didn't return the expected results.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically. A formula using QUERY() and IMPORTRANGE() functions was tried, but it didn't return the expected results.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

6 Replaced "following function" by "following formula" and formated the formula included as code.
source | link

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following codeformula

=QUERY(ImportRange("[key]","Sheet1!A:C"),"Select Col1, Col2 where Col1='"&A2&"'",1)

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following code

=QUERY(ImportRange("[key]","Sheet1!A:C"),"Select Col1, Col2 where Col1='"&A2&"'",1)

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

How do I get data from one Google spreadsheet A into spreadsheet B?
And when Spreadsheet A is modified, then Spreadsheet B also changes automatically.

UPDATE:

For example:

I have two spreadsheets Documents DocA and DocB

    A               B           C
1    uid                serial_no   ph
2   356307042189331 3123958     912345678900
3   356307046077540 3966305     923451245123
4   356307046092465 3966407     978458784578
5   356307046098678 3970932     971548745125

In DocB

    A               B
1   serial_no      uid
2   3123958
3   3284728
4   3284655

I am trying to get A2 from DocA into B2 in DocB with the following formula

=QUERY(
     ImportRange("[key]","Sheet1!A:C"),
     "Select Col1, Col2 where Col1='"&A2&"'",
     1
 )

I get

uid serial_no

in Cell B2 instead of the value in Cell A2 of DocA

    Tweeted twitter.com/StackWebApps/status/680776308822020096
5 added 813 characters in body
source | link
4 Title, grammar
source | link
3 edited tags
| link
2 added 73 characters in body
source | link
1
source | link