I want a formula that checks if any cell in column E contains any text at all. If it does, I want to output the information in cells from the same row.
So if E4 has text, I want to output the information from A4 and B4. I'm looking to create a list of names (last name is in column A and first name is in column B).
I figured out how to get a list of last names on a single sheet using =unique(filter(A2:219, E2:219=J1))
In J1 I placed a value I wanted to check column E for. There's two problems with this: 1) Most importantly, I cannot get this to work over multiple sheets and 2) I would like to check column E for any value rather than a specific one (though I can work around this if I can just get this to work on multiple sheets)
Any help would be much appreciated!
Hello,
Welcome to this forum.
As always it is always better to also provide a sample file showing the data and the structure, makes it easier to give spot on answers.
Some suggestions.
To check if the cell data is text or not, use the ISTEXT function. Gives TRUE if text, otherwise FALSE.
To do a lookup on multiple sheets, check this article.
Excel VLOOKUP Multiple Sheets • My Online Training Hub
Br,
Anders
