VLOOKUP function

[VEE-lookup ˈfʌŋkʃən]
nounpl: VLOOKUP functions
função 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 the VLOOKUP function to find the employee's salary based on their ID number.
Usei a função VLOOKUP para encontrar o salário do funcionário baseado no número de ID.
2. A lookup function commonly used in Microsoft Excel and Google Sheets for vertical data searches
The VLOOKUP function makes it easy to cross-reference data in large spreadsheets.
A função VLOOKUP facilita a referência cruzada de dados em planilhas grandes.
VLOOKUP is essential terminology in data analysis and business intelligence across Brazil, Portugal, and English-speaking countries. In Portuguese versions of Excel, it may appear as 'PESQUISERV' (concatenation of 'PESQUISA' and 'VERTICAL'), though English-speaking professionals and many bilingual users prefer the English 'VLOOKUP' designation. Understanding this function is considered fundamental in corporate data management training.
Synonyms / Sinônimos
vertical lookuptable lookupcolumn lookup
Antonyms / Antônimos
HLOOKUP functionINDEX MATCH

Regional Variations

General Brazilian
função VLOOKUP
Standard terminology used in business and education contexts
Portugal
função VLOOKUP
Same terminology; often called 'PESQUISERV' in Portuguese versions of Excel
USA/Canada
VLOOKUP function
Original English term; widely used in corporate and academic settings

Related Words

HLOOKUP functionINDEX functionMATCH functionspreadsheetExceldata lookupcolumn reference

Related Idioms & Phrases

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