jeudi 12 août 2021

GSheets VLookup array to search multiple tabs for multiple references

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