Loading…
Loading…
Practise MATCH on columns and rows, fill it down a list, find the position of the biggest value, and fix a MATCH whose range includes the header.
Syntax
MATCH(value, range, 0)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.