Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Excel 2019 Vlookup The Step-By-Step Guide, Paperback / softback Book

Excel 2019 Vlookup The Step-By-Step Guide Paperback / softback

Part of the The Excel 2019 Step-By-Step series

Paperback / softback

Out of stock

Description

The VLOOKUP formula made easy!

This 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.



****Includes downloadable exercise files****

The VLOOKUP and More:

  • The 4-parts of the VLOOKUP explained
  • Publishing VLOOKUP results
  • How to manage error messages using the IFERROR function with the VLOOKUP
  • What is wildcard functionality and how can it help me with my VLOOKUP formulas?
  • How can the INDEX and MATCH functions be used instead of the VLOOKUP?

    9 step-by-step exercises with downloadable files, including:
  • How to apply a basic VLOOKUP
  • How to use the VLOOKUP to Categorize Data
  • How to use the VLOOKUP to Calculate Totals
  • How to apply the VLOOKUP formula across multiple workbooks and worksheets
  • Using the IFERROR and VLOOKUP functions together to manage error messages

    In addition to the above, you will also learn how to troubleshoot and resolve common VLOOKUP errors, saving you hours of frustration:
  • What is causing the #N/A error message
  • Reasons why you may be getting the #REF error message
  • Why your VLOOKUP formula was working, but now you're getting the wrong values

    • Information

    • Out of stock

    • Format:Paperback / softback
    • Pages:90 pages
    • Publisher:Independently Published
    • Publication Date:
    • Category:
    • ISBN:9781080007981

    £6.99

    Out of stock
    Add to Basket
    Sign in to add to wishlist
     
    Free Home Delivery

    on all orders

     
    Pick up orders

    from local bookshops

    Information

    • Out of stock

    • Format:Paperback / softback
    • Pages:90 pages
    • Publisher:Independently Published
    • Publication Date:
    • Category:
    • ISBN:9781080007981