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 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.

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

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