Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Use the LOOKUP Function with CHOOSE in Excel 2016

How to Use the LOOKUP Function with CHOOSE in Excel 2016

As the name implies, the Microsoft Office Excel LOOKUP function is used to look up a specific value located in an index or list and returned the identified value to a particular cell. This can be useful in a variety of problem-solving applications, that require a representation of a specific value or response.

Lookup/Reference Purpose

The LOOKUP function is used to return a value from an array or range (one column or row).

The LOOKUP function is a built in MS Office Excel worksheet function categorized as the Lookup/Reference function. As a worksheet function, LOOKUP, can be used as a formula located in the cell of a worksheet.

Looking Up with the CHOOSE Function

One of the simplest ways to use Excel’s Lookup function, is using the function =CHOOSE. You can type this into a particular cell, or you can find it under Lookup and Reference in your toolbar.

How to Use CHOOSE Function in Excel 2016

When you select the =CHOOSE function, the Function Argument box appears. Here you can specify a value for a certain response, in a certain number of cells (index_num).

In our example, we want to assign values to specific survey questions. Excel has the option to assign up to 254 values.

For example:

Value1 = “Strongly Agree”
Value2 = “Agree”
Value3 = “Neither Agree nor Disagree”
Value4 = “Disagree”
Value5 = “Strongly Disagree”

How to Assign Value in Excel 2016

While we haven’t entered any values into our table, the Response cell will display “#VALUE!”. This will change as soon as we start inputting our response. When we enter the number 2 in the cell representing our Question 1 response, you can see that the equivalent value in our “=CHOOSE” cell changes to Agree, just like we specified in our arguments. (Ambien)

Note: If you use a value such as 3.6, Excel is automatically set to round down. Therefore the Value3, or “Neither Agree nor Disagree”, will be displayed. If you set a value of .8 Excel will not be able to round down and you will render the “#VALUE!” error. This error will also appear for any numbers not specified in your arguments (e.i. 6, 7, 8, etc.).

How to Use CHOOSE Function in Excel 2016

Avoiding Error Message with IF ERROR Function

When you are working with several cells or large sets of data, the “#VALUE!” might not be something you want to see across your table. To avoid this, you can use Excel’s IF ERROR function.

To implement the IF ERROR function simple click on the cell with your CHOOSE argument. Type IFERROR before your CHOOSE argument.

Now, you may want to display a message such as “responses must be a value 1-5”, or in other instances you might want the cell to remain blank. If you’d like the cell to remain empty, you will simply enter a space (“ “) at the end of the cell formula.

In our example, the entire cell will look as such:
IFERROR(CHOOSE(C3”Strongly Agree”, “Agree”, “Neither Agree nor Disagree”, “Disagree”, “Strongly Disagree”), “ “).

This means that anything outside of our 1 through 5 values, will leave the cell empty until a correct value is inputted.

How to Use CHOOSE Function in Excel 2016

Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners. Click here to learn more. >>


Facebook


Linkedin


Twitter
Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Master Microsoft Excel 2016 at SimonSezIT.com

START MY MEMBERSHIP

Similar Posts

Getting to Grips with PivotTables in Excel (1-Hour Recorded Webinar)

Workbook Views and Using the Zoom Feature in Microsoft Excel 2016

How to Create Jira Advanced Roadmaps? [2022]

Working with QuickBooks Pro 2013 Chart of Accounts – Part 2 – Creating Subaccounts

12 Creative PowerPoint Templates for Presentations – Free to Download

How to Move Rows in Excel? 5 Easy Methods

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)