hi,

on Sheet1, column A to C I have the following numbers:


4 18 23
5 12 26
15 22
6 20
7 11 24
19
3 13
1
9 16
25
8
28
21
2
14 27


On Sheet2 I want to search for three numbers, say 7, 18, 24

7 will return = A5
18 will return = B1
24 will return = C5



I am try to use the Address and Match Function but only work for one column, how can I search the whole sheet1?

Thanks in advance,


Da80th