'How to import specific data from another spreadsheet in google sheet?
I'm trying to import specific data from another worksheet using the below formula. Reason being not to let other party to get hold of all the information, only the necessary data for them to work on.
Currently this formula not working. Any suggestions on how I can make it work?
=FILTER(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1h2Qbxs-SuFpcPZzB3-2-VzBh3FTA9dH5_oOmtgTpBSs/edit#gid=0","Sheet1!$A:$D"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1h2Qbxs-SuFpcPZzB3-2-VzBh3FTA9dH5_oOmtgTpBSs/edit#gid=0","Sheet1!$B:$B=Nepal!$B$2"))
Im trying to get data only related to Agent Ali.
Link to the test spreadsheet: https://docs.google.com/spreadsheets/d/1h2Qbxs-SuFpcPZzB3-2-VzBh3FTA9dH5_oOmtgTpBSs/edit?usp=sharing
Solution 1:[1]
You mention:
Im trying to get data only related to Agent Ali.
You can use this simple query formula:
=QUERY(IMPORTRANGE("______","Sheet1!A1:D"),"where Col2='Ali'",1)
(As always do modify ranges according to your needs)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | marikamitsos |