Thread: Lookup value
View Single Post
  #1   Report Post  
naghy
 
Posts: n/a
Default Lookup value

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?