3 ms·
Great idea! Note: some of the information you linked is out of date, e.g. the linked summary says 'You have to sort the LookupLabels by name for match to work'
by rahimnathwani 7y ago
Great idea!
Note: some of the information you linked is out of date, e.g. the linked summary says 'You have to sort the LookupLabels by name for match to work'. But MATCH() takes a third optional argument (match type) which, if set to 0, means you don't need to pre-sort your Lookup labels, and you have no risk of having an approximate match returned.
I wrote a short blog post with the Excel advice I most commonly give to colleagues, or when I've reviewed people's Excel sheets as part of a training session: https://www.encona.com/posts/excel-best-practices https://www.encona.com/posts/excel-best-practices
- LeonB 7y agoI like your best practices, and I like the format that you've used ("Don't do this; Do this instead; Why").