Very nice! I'm not sure exactly how that works but I did get the results.
However if I fill S26:U26 up or down the results are some what off base. Any
Ideas?

I will work with this to see if I can understand it better.

Nice Job Max! I will look back at this in the morning to catch any replies.
Luke

"Max" wrote:

Maybe this might satisfy your complex intents ..
In S26:
=IF(COUNTIF(OFFSET($A25,-(SUM($Q25:$R25)+1),$P25,3,3),P26),P26,"")
Copy S26 to U26. This checks each element in P26:R26 vs the array D17:F19
and returns match results in the same order, ie in your sample, it'll return
as: 1, 6, 4.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Luke" wrote:
Max, Example below G15:O26 are left blank to save space in this reply. All
cells have digits in reality with no blank cells.

In D17:F19 = 943, 178, 206 with respect to each cell.
In P26:R26 = 164 with respect to each cell. Note that numbers 1, 6, & 4
exist in D17:D19.
In S26:U26 = 146 (Result cells)

P25:R25 =334:
P25=3 means move right to left from P25, 12 columns, or, 4 sets of three
columns. Left horizontal movement, as it were, to D25:F25.
"ABC=4 DEF=3 GHI=2 JKL=1 MNO=0 PQR"

(Q25=3 + R25=4) = 7 means move up vertically 7 cells to D18:F18 from D25:F25.

Then compare P26, Q26 & R26 to the array D17:F19.
OR, If that is not possible then I could live with just finding and
comparing P26, Q26 & R26 with D18, E18, & F18 placing the results in S26,
T26, & U26 respectfully.

A B C D E F..G,H,I J,K,L M,N,O P Q R S T U
15 2 1 0 1 1 5 7 6 9
16 5 5 5 5 2 5 8 4 1
17 3 6 0 9 4 3 0 4 4
18 5 1 2 1 7 8 9 9 4
19 4 2 4 2 0 6 1 8 7
20 0 4 1 4 3 0 3 8 1
21 3 6 7 5 2 7 6 5 4
22 2 5 2 1 1 9 7 1 1
23 5 8 6 4 7 0 5 4 9
24 7 7 9 3 3 7 4 8 2
25 7 9 7 4 6 2 3 3 4
26 5 9 4 6 7 2 1 6 4 1 4 6
27 2 8 8 4 0 2 5 0 9

I hope this helps or at leaset makes better sense.
Luke