I'm using the importdata statement inside in Switch condition and it does not return anything nor give an error.
My formula:
=SWITCH(C5,"Desired Value",IMPORTRANGE("url to the google spreadsheet", "MyTab!A:E"),C5,"Another Value","Another Value Output")
So when it's "Desired Value" is prints nothing. If I write a separate IMPORTRANGE without SWITCH it works fine.
EDIT:
Example
Source File (from what I'm importing) link and the file with SWITCH statement link
Aucun commentaire:
Enregistrer un commentaire