All three are equivalent and return the same result - MARK. Any will work.![]()
=VLOOKUP(SMALL(I8:I14,1),I8:J14,2,) =VLOOKUP(SMALL(I8:I14,1),I8:J14,2,0) =VLOOKUP(SMALL(I8:I14,1),I8:J14,2,FALSE)
I used a bad verbiage saying "taking out the final argument", I meant remove the value after the comma or use 0 as NBVC suggested. Removing the comma too turns the default TRUE on and it stops working.
Bookmarks