How to use the CHOOSE function

Tip: How to use the CHOOSE function

In this video, we’ll look at how you can use the CHOOSE function.

Let’s look at three examples.

Here have some items listed with a numeric color code. We want to bring these names into the column D.

Now, since I already have the table already here, I could just use VLOOKUP and reference the table. I get the lookup value from column C, the table is the range H5:I7, locked with F4, the column is 2, and I need to use FALSE to force an exact match.


Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *