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!
Bookmarks