Use the INDEX & MATCH Functions to Perform Lookups

Have you every used VLOOKUP to do look ups from table to table? If you have you'd know there were some limitation on how it performs look ups, such as it would only lookup up the item in the first column of the table you are trying to bring data over from. There are ways to get around that limitation, but another method is to use the INDEX & MATCH functions to perform table look ups. It might be scary at first, but once you get the hang of using these two function together, you'll find it very useful. Check out the video to see how.