Forum Discussion

rafi97cteep's avatar
rafi97cteep
Copper Contributor
Apr 12, 2022
Solved

PROCV and IF

Hi guys,   I have this table 1 in my excel, who that contains the information I'm looking for in the procv!!   I need to extract this information (which is in a tab) and bring it to another...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Apr 13, 2022

    rafi97cteep 

    =VLOOKUP(H18,CHOOSE({1,2},$B$2:$B$8,$A$2:$A$8),2,FALSE)

    Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. It is also possible to look for the "Parte Descrição" and the "Tipo de Equipamento" and then return "Parte Código" with PROCV. There are different possibilities in the attached file.

     

    If you work with Office365 or 2021 you can use XLOOKUP (PROCX) to do this. 

rafi97cteep's avatar
rafi97cteep
Copper Contributor
Apr 13, 2022

OliverScheurich 

 

Yes it is 🙂

 

But the text returns the number, that is, when looking for the "Parte Descrição" the procv must return "Parte Código"

Can you help me again?

Spoiler
Spoiler



like this:


 

 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 13, 2022

rafi97cteep 

=VLOOKUP(H18,CHOOSE({1,2},$B$2:$B$8,$A$2:$A$8),2,FALSE)

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. It is also possible to look for the "Parte Descrição" and the "Tipo de Equipamento" and then return "Parte Código" with PROCV. There are different possibilities in the attached file.

 

If you work with Office365 or 2021 you can use XLOOKUP (PROCX) to do this. 

  • rafi97cteep's avatar
    rafi97cteep
    Copper Contributor
    Apr 14, 2022
    Thanks ur the best

Resources