Forum Discussion
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...
=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.
You can also use "Xlookup" instead. It is an alternate to Inde-x-Match.