Powerpivot handling over 64 arguements in a formula


  • SO power pivot can handle x amount of arguments in each formula but when I try to do the same formula on a standard excel sheet it errors out with the too many arguments.

    The formula just says if a=1 then XX1, if a=2 then XX2, etc for about 80-100 arguments.

    I've seen ideas where you can make a 2nd reference table that has 2 columns like...

    Letter       Doc #

    a              XX1

    b              XX2

    c              XX3

    Then something have your column like...

    =IFERROR(VLOOKUP('data sheet'!C2, [Doc #], 2, False), "")

    But I don't really understand this formula.

    Wednesday, July 24, 2013 2:46 PM


All replies