Did anyone used the function “Array contains element”, as for me, it seems to have a little bug.
If I have only numbers in the array and I try to find a number it doesn’t work, the moment I add also a letter, it works … but I only if I want to find letters … and I don’t need letters
Some suggestions or can we report this little bug ?
but lookup uses the values in a single column and I need the values from multiple columns.
I think the approach is different and I can’t get those to in a column, as the values are assign in a row … So, this isn’t a solution for me… but thanks for the help.
do you know if this could be fixed in the next period ?