If you have a pretty long range, you could use another range to do the
lookup. I have also added the below suggestion to the attachment.
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 10:15 AM, Maries talk2mar...@gmail.com wrote:
Hi,
Try it..
Great sam... very simple and easy
On Sat, Feb 25, 2012 at 3:24 PM, Sam Mathai Chacko samde...@gmail.comwrote:
If you have a pretty long range, you could use another range to do the
lookup. I have also added the below suggestion to the attachment.
Regards,
Sam Mathai Chacko
On Sat, Feb
Dear group,
I want to make bucket of age like 0-2,2-4,4-6 etc.
However I can do this by if formula.
But that is very lanthy formula and also excel 2003 dose not support nested
if greater then 7.
So can anyone pls help me with any shortest way to do it pls.
Regards
Pankaj k pandey
--
FORUM
Hi Pankaj,
You can use Lookup function.
please find the example sheet.
On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot secrets...@gmail.com wrote:
Dear group,
I want to make bucket of age like 0-2,2-4,4-6 etc.
However I can do this by if formula.
But that is very lanthy formula and also
Hi,
Try it..
*=VLOOKUP(A1,{0,0-2;3,2-4;5,4-6;7,6+},2,TRUE)*
**
*=LOOKUP(A1,{0;3;5;7},{0-2;2-4;4-6;6+})*
Regards,
MARIES.
On Fri, Feb 24, 2012 at 11:31 PM, xlstime xlst...@gmail.com wrote:
Hi Pankaj,
You can use Lookup function.
please find the example sheet.
On Sat, Feb 25, 2012 at