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.