.. then on B6 : the result is X1y1Z1 ?
The prob you faced was because you had a "1" in C1 (within the reference
range C1:E3)
which would be found in "X1", "y1", "Z1" (in F6:H6) by FIND

Try the EXACT rendition given earlier. Seems to work fine.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---