In this video, we will look up two values in cells A1 & B1, find a match in two other columns of data and return a result from a third column from that same matching row. We will utilize the INDEX and MATCH functions while using Array formulas in the process.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!