View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry Mitchell[_2_] Jerry Mitchell[_2_] is offline
external usenet poster
 
Posts: 1
Default ...

A little extra that REALLY makes it weird. What I'm actually using is
=LOOKUP(SMALL(I2:I11,1),I2:I11,A2:A11), I just tried the above to narrow down
the problem.
Using ANY of the values besides 1st smallest works just fine with these
arrays, including returning the value in A2 with
=LOOKUP(SMALL(I2:I11,2),I2:I11,A2:A11).
Using =LOOKUP(SMALL(I2:I11,1),I3:I11,A3:A11) WORKS FINE! It's only when the
array includes I2 that it screws up looking for I4.. and ONLY screws up when
looking for I4 specifically. !?!