trying to combine
=ARRAYFORMULA(IF(Options!C9="Cyclon",IMPORTRANGE("1nvZwulmKkuhBNNgltZzR7VYqjrx0LMWuT7v9Kpjnn10","'Standard, Cylon Backbox'!A:F"),IMPORTRANGE("1nvZwulmKkuhBNNgltZzR7VYqjrx0LMWuT7v9Kpjnn10","'Floating Backbox'!A:F")))
With
=ARRAYFORMULA(IF(Options!C3="AE",IMPORTRANGE("1nvZwulmKkuhBNNgltZzR7VYqjrx0LMWuT7v9Kpjnn10","'Arcade Cabinet'!A:F"),IMPORTRANGE("1nvZwulmKkuhBNNgltZzR7VYqjrx0LMWuT7v9Kpjnn10","'Xtra Cabinet'!A:F")))
Separately they work great, but I would like to combine them to get them all in order together. Please help.
Aucun commentaire:
Enregistrer un commentaire