vlookup; reverse range of array

[Sri94]

Hello.

I have column a and colm b.. Colm a consists of a range aa,aa,aa,ab,ab,ab,ab.... Colm b consist of the ranking of colm a in the order 1,2,3,1,2,3,4... Now am trying an array formula if(b1=large(vlookup(a1,a1:b7,2),1),"Y","N") this is giving me y while it should give n....probably because vlookup refers to.the first values first as the range. Can someone help me fix this??

please excuse no table.. Query posted from handphone

[Pauleyb]

I think this is what you are looking for (it is an array formula):
=IF(B1=MAX(--(A1=$A$1:$A$7)*$B$1:$B$7),"Y","N")

[Sri94]

Thank u!! That helped!!