Formula SE + PROCV ending in #VALUE!

Asked

Viewed 89 times

0

Guys good afternoon.
The formula below is ending in error #WORTH!.
The formula is comparing words with hyphenation, I don’t know if it influences anything.

=SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE WORKFLOW";"")
excel fórmula procv
  • 2

    you can post a print of the data or post an example file indicating the expected result so that it is easier to reply.

  • But the PROCV function returns either the searched value or an error. What you consider to be true or false for the SE function criterion?

  • Maybe you should use: IS.NO.DISP(PROCV(R25;'TABELA1'! A:A;1;0)).

  • i followed the example here http://www.filetolink.com/d42e073229

1 answer

1


=SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE WORKFLOW";""), Voce needs to define what the SE, what Voce wants procv to return, whether it will be equal to something, or greater/lesser, needs to set this and then Voce will show the condition "Worflow Error" or "";

  • Please read How to format

  • 1

    @danieltakeshi vlw, sorry for the delay, I read about formatting, I’m paying attention to these items. thanks !!

Browser other questions tagged excel fórmula procv

You are not signed in. Login or sign up in order to post.