There are many ways to find and retrieve data from a table or range based on a lookup value. In fact, because Microsoft often comes up with new, modernized alternatives, there are too many ways! So, ...

If you would like to follow along in using these functions, you can download this Excel workbook and view the video at the end of this item. Let’s do some examples to see how these functions work. We ...