Alright, so I want a formula that would search in a column of words a specific word, I was helped at making one but it only logs the first one and stops there (even though it's not the one I want it to find)
=ARRAYFORMULA(IFERROR(VLOOKUP(A1:A50, IMPORTRANGE("(sheetid)", "Project Automation Checker!B1:D50"), {2,3}, 0))).
I want it to find the word "CT" in column D of the Project Automation Checker. https://docs.google.com/spreadsheets/d/1n8DF771658l-7lIMu2Jx7YF9ZoHGb3H8UA0eOVd8iaE/edit?usp=sharing
Aucun commentaire:
Enregistrer un commentaire