(816) 744-5565 | INFO@VALORGROUP.ORG
  • Home
  • About Us
    • About Us
    • Careers
  • The Valor Solution
    • Skills Catalog
    • Quick Training
    • Custom Training
    • LMS
    • Our Partners
  • Resources
  • News
    • Valor Voice
  • Contact Us
  • Request a Demo
(816) 344-5000 | INFO@VALORGROUP.ORG
  • Homepage
  • About
  • Careers
  • Solutions
  • Skills Catalog
  • Quick Training
  • Custom Training
  • LMS
  • Our Partners
  • Resources
  • News
  • Valor Voice
  • Contact Us
  • Request a Demo
(816) 344-5000 | INFO@VALORGROUP.ORG
  • Homepage
  • About
  • Careers
  • Solutions
  • Skills Catalog
  • Quick Training
  • Custom Training
  • LMS
  • Our Partners
  • Resources
  • News
  • Valor Voice
  • Contact Us
  • Request a Demo
Arithmetic Operations
March 23, 2022
Using PivotTables
March 23, 2022

Using VLOOKUP and HLOOKUP

Categories
Tags

When you have a small list of data, such as a phone list or a price list, it’s easy to scan the list
and look up specific information. If the list is large, the task becomes much more difficult. The
VLOOKUP and HLOOKUP functions help you look up information in an Excel spreadsheet.
By the end of this course, you will be able to
• Explain the purpose of the VLOOKUP and HLOOKUP functions
• Define the terms lookup value and return value
• Describe how data must be arranged for the VLOOKUP and HLOOKUP functions to
work correctly
• List the syntax of the VLOOKUP and HLOOKUP functions
• Explain the difference between approximate matches and exact matches when using the
VLOOKUP and HLOOKUP functions

Course ID Number: MSO-3001

Share
0

A Member of the BERKS Group.

PHONE
(816) 744-5565

ADDRESS
825 EDMOND STREET
ST. JOSEPH, MO 64501

EMAIL
INFO@VALORGROUP.ORG


Popular Pages

  • News
  • Careers
  • Resources
  • Skills Catalog
  • Solutions
Connect With Us
Loading
© 2022, Valor Manufacturing Training, Inc.
      Request A Demo