Tags: CHOOSE

Summarise data based on an unknown combination of conditions

{ 0 Comments }

By Ashish Mathur · March 20, 2013 · DATA SUMMARISING · Leave a comment

Data on the sheet named “Sales Data Master” shows the Territory wise, Show Title wise and Sales man wise forecast and actual data. One may want to summarise data based on an unknown combination of conditions. Conditions may be entered as: 1. All three conditions specified 2. No condition specified 3. Only first condition specified […]

Extract data from unknown lookup range

{ 14 Comments }

By Ashish Mathur · October 23, 2008 · DATA EXTRACTION · Leave a comment

The VLOOKUP() function accepts a definite lookup array (second input in the VLOOKUP()) specified by the end-user. In a situation where the lookup array is unknown, a function may have to cycle through various lookup ranges to cull out the required value. You may refer to my solution in this workbook.