Forum Discussion
Excel Formula to Search a Field in a Table Using If Condition and Procv or Procx
=ÍNDICE($D$3:$D$19;CORRESP(1;(F3=$A$3:$A$19)*(G3>=$B$3:$B$19)*(G3<=$C$3:$C$19);0))
You are welcome. Unfortunately i only gave you the english translation of the formula. This time i've translated the formula into portuguese.
Hello OliverScheurich! Thank for your greatreply! I have the following error:
I think Its because my version of Office 2109 is in portuguese! How can I turn this around?
Best regards,
Joaquim Guedes
=ÍNDICE($D$3:$D$19;CORRESP(1;(F3=$A$3:$A$19)*(G3>=$B$3:$B$19)*(G3<=$C$3:$C$19);0))
You are welcome. Unfortunately i only gave you the english translation of the formula. This time i've translated the formula into portuguese.
Hello OliverScheurich! Thank you very much for your precious answer! It worked very well!
All the best to you!
Beste regards,
Joaquim Guedes