{"product_id":"excel-2019-vlookup-the-step-by-step-guide-9781080007981","title":"Excel 2019 Vlookup The Step-By-Step Guide","description":"\u003cb\u003eThe VLOOKUP formula made easy!\u003c\/b\u003eThis in-depth and practical training guide will walk you through the basic and advanced VLOOKUP functionality in easy to follow step-by-step exercises. Saving you time and allowing you to grow your skill level at your own pace.\u003cb\u003e****Includes downloadable exercise files****\u003c\/b\u003e\u003cb\u003eThe VLOOKUP and More: \u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eThe 4-parts of the VLOOKUP explained\u003c\/li\u003e\n\u003cli\u003ePublishing VLOOKUP results\u003c\/li\u003e\n\u003cli\u003eHow to manage error messages using the IFERROR function with the VLOOKUP\u003c\/li\u003e\n\u003cli\u003eWhat is wildcard functionality and how can it help me with my VLOOKUP formulas?\u003c\/li\u003e\n\u003cli\u003eHow can the INDEX and MATCH functions be used instead of the VLOOKUP?\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cb\u003e9 step-by-step exercises with downloadable files, including: \u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eHow to apply a basic VLOOKUP\u003c\/li\u003e\n\u003cli\u003eHow to use the VLOOKUP to Categorize Data\u003c\/li\u003e\n\u003cli\u003eHow to use the VLOOKUP to Calculate Totals\u003c\/li\u003e\n\u003cli\u003eHow to apply the VLOOKUP formula across multiple workbooks and worksheets\u003c\/li\u003e\n\u003cli\u003eUsing the IFERROR and VLOOKUP functions together to manage error messages\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003eIn addition to the above, you will also learn how to troubleshoot and resolve common VLOOKUP errors, saving you hours of frustration: \u003cul\u003e\n\u003cli\u003eWhat is causing the #N\/A error message\u003c\/li\u003e\n\u003cli\u003eReasons why you may be getting the #REF error message\u003c\/li\u003e\n\u003cli\u003eWhy your VLOOKUP formula was working, but now you're getting the wrong values\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e C. J. Benton\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Independently Published\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/13\/2019\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 90\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.30lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.21h x 6.14w x 0.19d\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781080007981\u003cp\u003e\u003ci\u003eThis title is not returnable\u003c\/i\u003e\u003cbr\u003e\u003c\/p\u003e","brand":"Independently Published","offers":[{"title":"Paperback","offer_id":40621735444595,"sku":"9.78E+12","price":12.72,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0555\/9255\/0515\/products\/img_0d25aa12-b2a4-4698-a3ef-2c83e1bff6d5.jpg?v=1670597385","url":"https:\/\/bookstorenmore.com\/products\/excel-2019-vlookup-the-step-by-step-guide-9781080007981","provider":"Bookstore N More","version":"1.0","type":"link"}