สอนใช้ INDEX + MATCH แบบสั้นๆ เท่าที่จำเป็น
index match Using INDEX-MATCH or INDEX-MATCH-MATCH provides a more flexible way to index into two-dimensional arrays There is also evidence that it can The INDEX function can return an item from a specific position in a list The MATCH function can return the position of a value in a list The INDEX MATCH
Overcome the limitations of VLOOKUP Get up to speed with Excel INDEX & MATCH formulas This is a very crafty use of the INDEX function INDEX is a way of referencing the whole Range in a formula without needing to enter the formula as an
INDEX MATCH is better for a few reasons Firstly, VLOOKUP only works if the column you're searching is the first column of the table INDEX and The manager uses the following formula:=MATCHIn this formula, '0' represents an exact match The number five appears in cell D1