I want to extract the values of my second array from a calculated block of 15 lines (array 1 = 5, array 2 = 3) called [Sales]. The result should be a 5 line block. For example the calc block is a combination of the following arrays:

“Country” = Canada, China, France, UK, USA; “Product” = Product 1, Product 2, Product 3

Which Openbox formula will allow me to extract all lines for array 1 but for product 3 only?

The correct answer is LOOKUP([Sales],”Product 3″,”Product”)