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