One way ..

Place in B1, normal ENTER will do:
=IF(AND(SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,F1,0))),SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,G1,0))),SUMPRODUCT(--ISNUMBER(MATCH($C$1:$E$3,H1,0)))),(F1&G1&H1)+0,"")

Copy B1 down to return the desired concat results as real numbers. Format
col B as Custom, Type: 000 to retain the appearance with leading zeros if
required. And if you want the concat results as text, just replace this part:
(F1&G1&H1)+0 with: F1&G1&H1 in the expression.

Note that the first line in your sample posted, viz the data in F1:H1, ie:
3,5,9 satisfies the criteria and you'd get the correct result: 359 in B1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Luke" wrote:
Thank you for being there to help us,
Is it possible to have a formula in colmn B that will look at any three
individual cells in the array C1:E3 and match them up to any one row from the
array F1:H11, then display a cancatenation of three like cells from array
F1:H11 in Colmn B?

I hope this example comes through well enough for you.
Thank you,
Luke
A B C D E F G H
1 1 6 3 3 5 9
2 0 0 1 7 4 4
3 100 9 8 5 1 0 0
4 2 1 3
5 6 4 3
6 168 1 6 8
7 1 6 4
8 3 3 4
9 4 4 4
10 950 9 5 0
11 8 8 7