How To Use VLOOKUP With An Array Constant In Excel HD

Here are some interesting ways you can use Array Constants in your VLOOKUP formula! You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. https://app.box.com/s/46d1nn7k21oaslxxdzeilxaxflm5c3bd