With prices in col. B and quantities in col. A, this'll
return the price for the 1st max qty found in col. A:

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

HTH
Jason
Atlanta, GA

-----Original Message-----
I have two colums, one with prices one with quantities

i want to lookup the max quantity and have the price for
that quantity shown
in another cell
but the problem is that there are 2 max quantities, so
the lookup formula
results in 0

how do i resolve this?
.