Most voted "procv" questions
12 questions
Sort by count of
-
3
votes1
answer29901
viewsExcel formula to search part of the text in a table
I have a table of banks and codes in two columns. Ex.: Banco do brasil S/A 001 Banco do Estado do Rio Grande do Sul - Banrisul 041 Banco Santander do Brasil 033 Banco Mercantil do Brasil 208 Banco…
-
1
votes2
answers2626
viewsHow to make a "procv" in Python using the Pandas library
good afternoon! I got csv down: Nome Vendas Produto Data Carlos 83,40 cod2 15/04/2020 Andre 70,50 cod5 10/04/2020 Cristina 100 cod7 25/04/2020 Carlos 20,80 cod1 03/04/2020 Gisele 10,50 cod9…
-
0
votes1
answer113
viewsPrevent the PROCV formula from returning an error
Is there any configuration in Excel or some way to make the PROCV formula, when it does not find the searched value, return empty ("") or 0 instead of the error "#N/A"?
-
0
votes0
answers230
viewsHelp in Procv to select data
I have a database where an employee has three dependents or more when I do a PROCV to pull one dependent at a time, appears only the first and the last. =PROCV(B35;'SÓCIOS COOP'!C:G;5;1) How do I…
-
0
votes1
answer110
views -
0
votes1
answer89
viewsFormula SE + PROCV ending in #VALUE!
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…
-
0
votes1
answer85
viewsFind duplicate values - Excel
How to return a company based on a value, even if the Matrix has several duplicates. You can return the first found.…
-
0
votes1
answer1236
viewsSum values with PROV
I have an Excel sheet with monthly spending per food. The goal is, on a separate sheet, to calculate the sum of each food in every month. With the formula I’m using right now…
-
0
votes1
answer123
viewsHow to use PROCV to search for code in two spreadsheets?
In Excel 365, version 1907, and Windows 10, I have an XLSX file with two almost equal sheets - Sheet 1 and Sheet 2. Contents of the Spreadsheet1: Contents of the Spreadsheet2: I want to check in…
-
0
votes1
answer67
viewsFunction "Procv" with pyspark
I am beginner and would like to know if there is any code to correlate two spreadsheets by means of index (CAUSE_CODE), like a PROCV in Excel, but in Pyspark. %pyspark machine_A_grouped =…
-
0
votes1
answer24
viewsProcv without the last character
I have a procv, where I wrote the following: SE(ÉERROS(PROCV($A2;'PLAN2'!$A:$C;1;0));"Não Encontrado";"Encontrado") It works very well in exact cases of searching for values, but some cases have…
-
-1
votes1
answer2411
viewsHow to compare two separate columns in excel and check if the data of one is inside another?
If you could help me with this case, I’d really appreciate it. I am trying to make a column with the comparison filter between two columns of excel, returning the value that are common to the two…