I am using VLOOKUP to return the addresses for my bottom stores to basically take out sorting as well as do a few other things, my problem comes if there are multiple instances of the same #. Here is a small example:


$10 ROGERS
$11 HARRISON
$16 COMMERCE
$25 SILOAM SPRINGS
$10 CONWAY
$17 SHERWOOD

To return the stores I want I am using the following formula =VLOOKUP(SMALL(Sheet2!J:J,ROW(C1)),city,2,FALSE) which is all fine and dandy for the worst store in this case Rogers, but instead of listing Conway as my second worst is lists Rogers again. any ideas?

Thanks!