SOLVED

What's wrong with this formula?

Copper Contributor

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(SEARCH("MC21",C6)),FILTER(Table13[MASIA],Table13[[Descripcion ]]=GASTRONOMIA!C18,""))

3 Replies
best response confirmed by johnnycasali365 (Copper Contributor)
Solution

@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),
   "")
)
I see the error now. Thank you very much Sergei.

@johnnycasali365 , you are welcome

1 best response

Accepted Solutions
best response confirmed by johnnycasali365 (Copper Contributor)
Solution

@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),
   "")
)

View solution in original post