jeudi 18 juillet 2019

Google Sheets Importrange statement in SWITCH

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