Curly brackets / arrays in if statement formulas

Your formula returns an array of True/False results, not a single result if any match is made. You would need something like an OR, MATCH or SUMPRODUCT function if you want one result of True if any of them match.

Your explanation would have been easier to follow if you had attached a sheet, so that we can see exactly what was there. however, I'd probably use something like this:

=IF(ISNUMBER(MATCH(A1,$C$1:$C$5,0)),TRUE,FALSE)

see sheet

Thanks. I used the Isnumber() statement instead. What I was trying to do was to pull a specific part of a string based on the last character of a left() statetement. Lucky for me, the characters are all numbers so this works fine.

Sorry I would have thought the attached picture gave a pretty good indication of what I meant.

It's just strange because I see examples on the web, where arrays are used in IF statements with multiple criteria and seem to work in some cases. Also I find it strange that the formula returns a "True" if the first value in the array is a met but returns a "False" for all other following values.