Value Formulas – Reference further details

​Demonstrates the extraction of reference information into Excel cells based on a unique driver value.  In the example a product no is entered into a cell and the product name, colour and list price are displayed in 3 other cells.  A Value Formula Query using Reference Query Mode Reference is used to extract the values.  As there is more than one value extracted Excel Formula Arrays are used to display the 2nd and 3rd value using the method Select Range,Press F2 then Control+Shift+Enter.

​