How to search for values using the MATCH and LOOKUP functions in Excel
When dealing with large datasets, searching and indexing data points you want to track is arguably one of the most important tasks. That's exactly what the MATCH and LOOKUP functions are designed to do. In combination with other functions that we've previously talked through on the channel such as AVERAGEIF, tools like these can save you countless hours during data analysis