So I have a Google sheet with multiple tabs and need to reference data in column A in order to display the data in rows B, C, D, E etc
Here's what I currently have: =ArrayFormula(IF(lEN(B4), IFerror(VLOOKUP(T(B4),{Data1!$A$1:$A$561; Data2!$A$1:$A$673; Data3!$A$1:$A$1217, Data4!$A$1:$A$1217},1,1,FALSE),"Not found"),))
I'm not getting any errors, but I'm also not getting any results, even using exact values so it makes me think I'm missing something. Any ideas?
Aucun commentaire:
Enregistrer un commentaire