Bernd wrote:
Hi Steve,

An example:

Enter into cells A1:C4
a b c
b a c
A B C
C A B

Then select cells D1:E4 and enter as array formula (enter with CTRL +
SHIFT + ENTER, not only with ENTER!):
=ArrayMatch("a",$A$1:$C$4)

Your output will be
1 1
2 2
3 1
4 2

Because the default mode ignores case.

Array-enter into F1:G4
=ArrayMatch("B",$A$1:$C$4,FALSE,1,TRUE)
and your output will be
3 2
4 3
#NV #NV
#NV #NV

Because the 5th argument of TRUE requires case-matching.

You'd get the same result with
=ArrayMatch("B",$A$1:$C$4,,,TRUE)

Alan Beban