Excel LOOKUP Function Only PROS Use (simple to complex examples)

The LOOKUP function in Microsoft Excel has the ability to return data from any column that you specify, including one to the left of the column you are looking within. Its default behavior makes it useful for solving certain problems in Excel. The problem with this function is that it can return wrong results if it's not used properly. That's why many people use the VLOOKUP function instead of LOOKUP. However once you understand why you're getting wrong results and how the Lookup function really works, you can use it to solve simple to complex lookup tasks in Excel.

00:00 How to Use Excel LOOKUP Function
00:39 LOOKUP Basics
04:42 LOOKUP Advanced
10:00 Alternative XLOOKUP
11:21 Wrap Up