Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

vlookup

Hello    I need to create a calculated column from other column wich shows certain quantity , when the column "Planta" and the column "Centro_Receptor" exchange positions I need the "cantidad" valu...
Need Help
Show and Tell
Tips and Tricks
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous

 

May be something like this

 

Column =
VAR VAL =
    LOOKUPVALUE (
        [Cantidad],
        [PLANTA], [CENTRO_RECEPTOR],
        [CENTRO_RECEPTOR], [PLANTA]
    )
RETURN
    IF ( VAL = [Cantidad], 0, VAL )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Zubair_Muhammad 

 

Thanks for the answer, unfortunatly it didnt worked, i think might be because I have other values in the "Semana" column and in the planta column


Do you think anorther solution?

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    To get the solution quickly, please share your sample data as table format and your desired output so that we can copy and test on it.

     

    Best Regards,

    Cherry