Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
AskJoe
Lv 7
AskJoe asked in Computers & InternetProgramming & Design · 9 years ago

vlookup range in excel?

I have a column of 15 numbers (from 0.12 to 3.74) not in any order. I am trying to put a number in the next column which calls them out from lowest to highest. I tried various v lookups with the range, but cant get it to sort them. Any ideas?

1 Answer

Relevance
  • expletive_xom
    Lv 7
    9 years ago
    Favorite Answer

    VLOOKUP() wont work for that...you need the SMALL() and ROW() function (that row function just counts to 15)

    make a test sheet and start at the top....your data is in A1 to A15

    then copy&paste this in B1

    =SMALL(A$1:A$15,ROW(A1))

    it should give you the smallest number.....then just copy B1 and paste down the column.

    then change stuff in column A randomly to watch it work.

    then apply to your real sheet.

    let me know how it works.

Still have questions? Get your answers by asking now.