I need a function that will match a name from a range of names
wich include multiple names of the same name , to find the lowest
number or numbers given to a name or multiple names eg:

sheet R! sheet K!
A W A K
1 mary 1 mary 2
2 mary 2 2 john 1
3 john 1 3 bill 2
4 john 4 anne "blank"
5 john 7 5 joe 1
6 bill 6 ivon "blank"
7 bill 5
8 bill 2
9 bill
10 anne
11 anne
12 anne
13 joe 3
14 joe 1
15 ivon

down to 1200 rows all names and numbers are at random sequinces

your help is much appriciated



--
bill gras