• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Working with Lookup Functions > Looking Up Values in Tables

Looking Up Values in Tables

As you've seen, the CHOOSE() function is a handy and useful addition to your formula toolkit, and it's a function you'll turn to quite often if you build a lot of worksheet models. However, CHOOSE() does have its drawbacks:

  • The lookup values must be positive integers.

  • The maximum number of data values is 29.

  • Only one set of data values is allowed per function.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint