Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Too much nesting in formula (https://www.askmehelpdesk.com/showthread.php?t=397026)

  • Oct 14, 2009, 12:33 PM
    JBeaucaire

    This will expand up to about 28 items, just add to each array in the correct position, and remember the first array is ordered.

    =LOOKUP(F20, {0,50000,100000,200000,300000,500000,750000,100000 0,1250000}, {"no way","*","**","***","****","*****","Silver","Gold" ,"Platinum"})

    Or, you could put that in a table in your sheet and just refer to it with cell ranges:
    Code:

              M          N
    1        0        no way
    2        50000        *
    3        100000        **
    4        200000        ***
    5        300000        ****
    6        500000        *****
    7        750000        Silver
    8        1000000        Gold
    9        1250000        Platinum

    =LOOKUP(F20, $M$1:$M$9, $N$1:$N$9)
  • Oct 14, 2009, 12:51 PM
    JBeaucaire
    I would not have concluded that these two threads constituted the same thing. The first question was FAR more complicated than the current topic.
  • Oct 14, 2009, 01:45 PM
    Helpinlasvegas1

    The first question I posted was more complicated, I had to have a number that posted, but there are two separate categories, that is why the first is more complicated. The current topic was easier for me, and thank you for all yor help

  • All times are GMT -7. The time now is 09:21 AM.