Getting VLOOKUP to return multiple values

This post is for the somewhat more advanced Excel user.

You may already be familiar with the VLOOKUP function, what you may not know is that you can get a single VLOOKUP formula to return multiple values by using an array.

1. Select each cell that you want to contain a result from the VLOOKUP.  In the screenshot below, the cells I4:K4 were selected
2. Switch to the Formulas tab, select Lookup&Reference, VLOOKUP
3. Specify the Lookup_value and Table_array as normal
4. Enter a column number for each column that you want data returned from.  Separate the column numbers by commas and enclose it all in braces / curly brackets {  }.  The column numbers can be specified in any order.  In the example below, data will be returned from columns {5,6,3}
5. Specify your Range_lookup requirements
6. Press CTRL, SHIFT, ENTER

Hope this is a time saver for you!  Please share if you think anyone might find this useful too.