INDEX MATCH
INDEX and MATCH together: find the position of a value, then return a cell from another column. It works in any direction.
Group: Lookup
Syntax
INDEX(return_range, MATCH(lookup_value, lookup_range, 0))Example
Exampleexcel
WeCodeAcademyWeCodeAcademyINDEX and MATCH together: find the position of a value, then return a cell from another column. It works in any direction.
Group: Lookup
INDEX(return_range, MATCH(lookup_value, lookup_range, 0))