{"product_id":"mastering-excel-mark-moore-9781974271474","title":"Mastering Excel: Vlookup","description":"You've heard the rumors, you've seen other people at the office work magic with it... \u003cp\u003e\u003c\/p\u003eCan you be one of the select few? \u003cp\u003e\u003c\/p\u003eVLOOKUP, the formula that strikes terror into the minds of Excel users. It's intimidating, it even sounds weird. What's it all about? \u003cp\u003e\u003c\/p\u003eIn this Excel lesson, everything will be revealed. You want to find the highest grossing salesperson from your data set? \u003cp\u003e\u003c\/p\u003eMaybe you need to build a dashboard that shows the best selling products. VLOOKUP can handle all these scenarios, and more. \u003cp\u003e\u003c\/p\u003eI'll explain exactly how it works, when you should use it and most importantly, how to fix it when it breaks. \u003cp\u003e\u003c\/p\u003eBut 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. \u003cp\u003e\u003c\/p\u003eWaait...there's more...Microsoft recently released a new function called XLOOKUP. \u003cp\u003e\u003c\/p\u003eXLOOKUP is what VLOOKUP wants to be when it grows up. This brand new function throws VLOOKUP and INDEX into the trash heap and never looks back. You can search starting at the top, from the bottom, you can go left, go right, the options are amazing. \u003cp\u003e\u003c\/p\u003eThis lesson comes with workbooks that you can use to follow along and practice what you read. By the time you are finished, you will be ready to use all these formulas in your files and save yourself hours of work. \u003cp\u003e\u003c\/p\u003eGet it now.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Mark Moore\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1974271471\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781974271474\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Createspace Independent Publishing Platform\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 08\/03\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 50\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.18lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.10d","brand":"Mark Moore","offers":[{"title":"Paperback","offer_id":44077108855039,"sku":"9781974271474","price":13.2,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_dedcb93a-ceb3-48b9-b3ea-ee6ec1719d10.jpg?v=1685468337","url":"https:\/\/www.whiterainbookhouse.com\/products\/mastering-excel-mark-moore-9781974271474","provider":"WR Book House","version":"1.0","type":"link"}