Try...

AI32, copied down:

=INDEX($AG$32:$AG$44,SMALL(IF($AF$32:$AF$44=AH32,R OW($AG$32:$AG$44)-ROW($
AG$32)+1),COUNTIF($AH$32:AH32,AH32)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
bill gras wrote:

i need to look up columns and match a number eg:
AH32 (25) match it in column AF(25) and return the result from column AG(4)
the result i get is 10 where it should be 4, i tried defferent ways but no
luck
i can not use VLOOKUP because i have the same numbers at times and need
multiple hits
AF AG AH result
32 blank 1 25 4
33 blank 2 14 2
34 14 2 11 3
35 blank 2 11 5
36 blank 3 11 6
37 11 3
38 blank 4
39 25 4
40 blank 5
41 blank 5
42 11 5
43 11 6
44 blank 6
and so on down to 300 rows
my array formula is :
{=INDEX(AG32:AG300,SMALL(IF(AF32:AF300=AH32,ROW(AF 32:AF300)),ROW(1:1)))}
coppied down to 5 rows as 1 only need 5 results

can some one please help ?

greatly appreciated

bill gras