Excel Just Taught Me a Valuable Lesson
The other day, I found out that the exact match in Excel isn’t exact as I
thought it was.
Let me explain.
For the MATCH
[https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a]
function, there are three different match types:
* 0 - Exact match
* 1 - Exact or next smallest