Forum Discussion
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" value in other column
For example for the week 51 form 1024 to 1023 is 166 and form 1023 to 1024 is 424, so the result must be
0
424
0
166
I need some help please!
3 Replies
Anonymous
May be something like this
Column = VAR VAL = LOOKUPVALUE ( [Cantidad], [PLANTA], [CENTRO_RECEPTOR], [CENTRO_RECEPTOR], [PLANTA] ) RETURN IF ( VAL = [Cantidad], 0, VAL )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?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
