Thanks Asa,
You rock man.
Regards
Shekhar Sharma
On Thu, May 10, 2012 at 3:13 AM, Asa Rossoff wrote:
> Hi Shekhar,
>
> Well, the prupose of the formula is, in the end, to lookup a text value
> based on an input value. This is best accomplished with a lookup function.
>
>
> ANY of th
Hi Shekhar,
Well, the prupose of the formula is, in the end, to lookup a text value
based on an input value. This is best accomplished with a lookup function.
ANY of the lookup functions could be used - LOOKUP, HLOOKUP, VLOOKUP,
CHOOSE, INDEX, etc.
Here is a version that utilizes SUMPRODUCT,
