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

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

Regards,
Bernd