Hi!
Possibly I've not got far enough in the course yet, but I think XLOOKUP should be able to do what I'm trying to make it do (I hope).
I want it to find ALL cells whose value matches my lookup_value and return the values of the return_array for each of them. I don't want it to only find the first match, but all of them, and list them with a spill or dynamic array.
Is this possible? And if not with XLOOKUP, is there another function combination that can do this?
And another question - I can't seem to make XLOOKUP find blank cells by writing the lookup_value as 0 or FALSE. Is there a way to make it do this?
Thanks very much!!
Hi Briana,
To find cells that match a criteria you should use the FILTER function.
To find a blank cell use "" as the criteria, as opposed to zero or FALSE. Mynda
I hadn't got to the FILTER section yet - I should've waited. Thank you!
