VLOOKUP

[vee-LOO-kup]
noun
PROCV (Procura Vertical) ou VLOOKUP
1. A spreadsheet function that searches for a value in the first column of a table and returns a value in the same row from a specified column to the right
I used VLOOKUP to find the employee's salary based on their ID number.
Usei PROCV para encontrar o salário do funcionário baseado no número de identificação dele.
2. An abbreviation for 'Vertical Lookup,' commonly used in Microsoft Excel and Google Sheets
The VLOOKUP formula syntax is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
A sintaxe da fórmula PROCV é: =PROCV(valor_procurado, matriz_tabela, núm_coluna, [intervalo_procurado])
VLOOKUP is a fundamental function in business and data analysis contexts across both Brazil and the USA. While Brazilian Portuguese officially uses PROCV (the translated equivalent), many Brazilian professionals use VLOOKUP interchangeably, especially in international or technical environments. Understanding VLOOKUP is considered essential knowledge in corporate settings and finance departments in both countries.
Synonyms / Sinônimos
vertical lookuptable lookupindex-match combination
Antonyms / Antônimos
HLOOKUPhorizontal lookup

Regional Variations

General Brazilian Portuguese
PROCV ou VLOOKUP
PROCV is the official Portuguese translation, but VLOOKUP is widely used in technical contexts
Portugal
PROCV
Portuguese standard uses PROCV consistently
Technical/International
VLOOKUP
The English term is commonly used in multinational companies and technical documentation regardless of location

Related Words

HLOOKUPINDEXMATCHspreadsheetformulaExcelGoogle Sheets

Related Idioms & Phrases

to run a VLOOKUP
VLOOKUP returns an error
VLOOKUP match not found
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →