What's wrong with this formula?

[johnnycasali365]

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

[#2 · Accepted 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),
   "")
)

[#3]

I see the error now. Thank you very much Sergei.

[#4]

@johnnycasali365 , you are welcome