Nidottu - Moore, Mark - You've heard the rumors, you've seen other people at the office work magic with it... Can you be one of the select few? VLOOKUP, the formula that strikes terror into the minds of Excel users. It's intimidating, it even sounds weird. What's it all about? In this Excel lesson, everything will be revealed. You want to find the highest grossing salesperson from your data set? Maybe you need to build a dashboard that shows the best selling products. VLOOKUP can handle all these scenarios, and more. I'll explain exactly how it works, when you should use it and most importantly, how to fix it when it breaks. But wait...VLOOKUP is powerful but it can't do everything. It has limitations and you'll also learn how to supercharge your Excel powers with the INDEX function. It does what VLOOKUP wishes it could do. Waait...there's more...Microsoft recently released a new function called XLOOKUP. XLOOKUP is what VLOOKUP wants to be when it grows up. This brand new function thro