In this “easy-learn” webinar, Ray Evans clearly demonstrates the essentials of VLOOKUP and HLOOKUP setup, structure, and options, and how this knowledge can significantly save time, preserve accuracy, highlight errors, and boost productivity.Lookup functions can match, retrieve, and merge data between tables with exact and range matches using absolutes and named ranges.VLOOKUP is an Excel function that looks up and retrieves data in a vertical table, where data is organized in rows.HLOOKUP is an Excel function that looks up and retrieves data in a horizontal table with data in columns.When it comes to dynamically matching and retrieving information from small or huge tables of data, Lookup functions can elevate you to a new world of accuracy, productivity, and time savings in Excel.To work efficiently with lookup functions, you must start with a clear understanding, good habits, and application of correct table and function structure and syntax.Mastering lookup functions and techniques is a valuable skill set in Excel and is vital in a wide range of professions and fields, including public service, banking, accounting, financial analysis, and business administration.Areas Covered Understanding VLOOKUP syntaxExamples of using VLOOKUPTrue and False - The 4th Parameter DemystifiedTable setup essentials for lookup functionsVLOOKUP Range Lookup using absolute referencesVLOOKUP Exact match using absolute referencesHLOOKUP Range Lookup using absolute referencesHLOOKUP Exact match using absolute referencesCleansing data for VLOOKUP accuracyFormula Auditing to trace, edit, and correct formulas and functionsKeyboard shortcuts – Excel, general, and web browserWho Should Attend All Excel UsersAccount ExecutivesAccountantsAuditorsBookkeepersBusiness OwnersChief ExecutivesControllersCPA'sCybersecurity staffDatabase Administrators (DBA)EducatorsTrainersEngineersFinancial AnalystsHuman Resource PersonnelIT ProfessionalsManagersMarketersNew RecruitsProject ManagersSocial Media SpecialistsStaff at all levelsSupervisors