Forum Discussion
PROCV and IF
=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.
=INDEX($B$2:$B$8,MATCH(1,($A$2:$A$8=N6)*($E$2:$E$8=Q6),0))=VLOOKUP(N2&Q2,CHOOSE({1,2},$A$2:$A$8&$E$2:$E$8,$B$2:$B$8),2,0)Is this what you want to do? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
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?
=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.
- Thanks ur the best
- sorry the spoilers
