Quick tutorial on combining the INDEX and MATCH functions in Excel; a great alternative to VLOOKUP that is faster and more efficient.
Function: =INDEX(B1:B9, MATCH("Bob", A1:A9, 0))
Feel free to drop questions below.
#excel #tutorial
...
https://www.youtube.com/watch?v=Rt8Ei5CzeIg