INDEX/MATCH
[ˈɪndɛks / mætʃ]
noun
ÍNDICE/CORRESPONDÊNCIA
1. A spreadsheet formula combination that searches for a value in a range and returns a corresponding value from another range, more flexible than VLOOKUP
Use INDEX/MATCH to find the employee's salary based on their ID number from the database.
Use ÍNDICE/CORRESPONDÊNCIA para encontrar o salário do funcionário com base no número de identificação do banco de dados.
2. A technique combining two functions: MATCH locates the position of a value, and INDEX returns the value at that position
The INDEX/MATCH formula is more powerful because it works with data in any column direction.
A fórmula ÍNDICE/CORRESPONDÊNCIA é mais poderosa porque funciona com dados em qualquer direção de coluna.
INDEX/MATCH is predominantly used in technical and business contexts, particularly among professionals working with Excel and data analysis. The term is often kept in English even when speaking Portuguese, especially in Brazil's corporate and tech sectors. It represents a more advanced spreadsheet skill compared to VLOOKUP.
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →