 What's our next shortcut number 10? Shortcut number 10 is quickly create an array to use in a formula. Quickly create an array. What's an array? When we do a VLOOKUP, for example, and we highlight the table, we say, okay, VLOOKUP this in this and return that. That table we are highlighting is called an array. So there are some times that you don't want to keep on looking for the table. You want a permanent table to look up. You can actually create a permanent table with this trick. So quickly create an array for use in a formula. Let's see how that trick works. So month in the year, January to December. Let's do that. January to December. All right. Now, and I want to know, okay, which month? January is month one, month two, month three. So January is month one, month two, month three. Normally, I would do a VLOOKUP like this. Let me just highlight. I want to know, okay, what month is the month of April? APR. So I want to know, what month is APR? You do your typical VLOOKUP APR in this table. You look up APR in this table to our luck with F4, comma two, comma zero. That gives me four, which is fine. April is four. But why don't we just take this whole table and put the whole thing into a formula? So we don't need to always have this table. This table is automated. So to do that automation of this table, or to kind of extract this table all into the formula, you do equals to in a cell and you highlight your table. When you should just do equals and highlight your table and enter, it will give you an error, which is fine. Because when you press F2 and F9, it breaks down that thing you highlighted into text, into an array. So here you can see Jan 1, Feb 2, March 3. So there are some tables that will never change. They're just standard tables. You can actually break them down into an array, like I've just done here. How did I do that? I simply did equals to highlight the table, enter. You can go back to the cell and press F2 and then F9. F9 breaks it up, F9. And then once you do that, you control C. You copy that formula. Once you copy it, you can now go into VLOOKUP. And in your VLOOKUP, you can say, hey, I'm looking for this cell. I'm looking for it in a table, but the table is going to be control V and just pasting your entire array. That thing you broke down. You're pasting it in there. And they say, give me column two or give me zero. So once you do that, you get the same four. But guess what? This four doesn't need this table anymore. You don't need this table. So this fresh formula will not work, but this second one works. And look at it. It looks ugly, but you basically extracted the whole table, broken it down and put it into the formula. And there are some tables that you have that you don't need to like your regions or markets or stores or stuff like that. You can just break it all down and put it into the formula. That's how you create arrays. That's how you create arrays. Okay, so that was that shortcut. Thanks for watching another training video from DeepRound Consulting. See you in the next video.