Forum Discussion

johnnycasali365's avatar
johnnycasali365
Copper Contributor
Jan 11, 2022
Solved

What's wrong with this formula?

Hi, this formula returns #value error and I can't figure out why. Thnak you    =IF(ISNUMBER(SEARCH("ES21",C6)),FILTER(Table13[ESFERIC],Table13[[Descripcion ]]=GASTRONOMIA!C18,"")),IF(ISNUMBER(SEAR...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 11, 2022

    johnnycasali365 

    Perhaps you mean something like

    =IF(
   ISNUMBER(SEARCH("ES21",C6) ),
   FILTER( Table13[ESFERIC], Table13[[Descripcion ]]=GASTRONOMIA!C18) ,
IF(
   ISNUMBER(SEARCH("MC21",C6) ),
   FILTER(Table13[MASIA],Table13[[Descripcion ]]=GASTRONOMIA!C18),
   "")
)
johnnycasali365's avatar
johnnycasali365
Copper Contributor
Jan 11, 2022
I see the error now. Thank you very much Sergei.

Resources