Mar 09 2023 08:51 AM
Hello,
so i have this issue with my table:
i want my cell on the "result" table to calcul a different formula according to 2 criterias in a "database" table. i manage to rechercheV my formula so it appears in the cell, but the calcul of the formula is not happening
table "result" :
criteria 1 - criteria 2 - My cell
table database
column A : combinaison of criteria 1&2= 32 differentes lines
column B : 32 lines corresponding to 32 differents formula to apply in my cell depending on criteria 1&2 combinaison
so my formula was:
RECHERCHEV(CONCATENER([@criteria1];[@criteria2]);Tableaudatabase;2;FAUX))
(sorry my formula is in french)
but with this formula, my formula appears as a text and isn't calculated
which fonction do i use to make so my formula is calculated?
thanks to helpers + sorry for bad english
Mar 27 2023 01:02 AM
@Hans Vogelaarsorry i didn't send the righ sheet, this one is the one
Mar 27 2023 01:45 AM