What is MATCH? 🧐 Tell "sequence" and not "value."

Have you ever wanted to know how much "Code A-123" is in the big table, or "This Customer's Name" is in the order of the list? 😩

1.What is MATCH? 🧐 Tell "sequence" and not "value."

The heart of MATCH is not to extract the value of the data, but to respond to the number of data we are looking for in the order of the data we choose.

Structure: = MATCH (desired value, data range used to find, 0)

(The last 0 means to find the exact exact corresponding form, which we use most often)

2. Deadwood Pose! ✨ INDEX + MATCH (The Formula Pro He Used)

When MATCH works with INDEX, it becomes a much more powerful and flexible data search formula than VLOOKUP!

MATCH acts to find out where it is.

INDEX acts to "pull out the value in that row."

3.Upgrade to XMATCH & Summary 🚀

For Excel 365 users: Now there's a new formula, XMATCH, that's even better than traditional MATCH! It's easier to use and more flexible.

In summary, remember simply:

- MATCH: Tell me the "position" (order) of the data.

- INDEX + MATCH: Use a pair to "retrieve" gods (better than VLOOKUP)

- XMATCH: is an upgraded version of MATCH for new Excel.

# Excel trick # ExcelTips # Office # Work # INDEXMATCH# VLOOKUP # Lemon8HowTo