mercredi 26 mai 2021

Tring to combine multiple formula's/Statements into one

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