thanks all of you.
Regards,
Aamir Shahzad
On Mon, Nov 28, 2011 at 10:22 AM, NOORAIN ANSARI
wrote:
> Dear Aamir,
>
> You can also try.
> *=LOOKUP(C4,$F$9:$G$14)*
>
>
> 0 upto 50 M
> 51,000,000 51- to 100M
> 101,000,000 101 to 300M
> 301,000,000
Dear Aamir,
You can also try.
*=LOOKUP(C4,$F$9:$G$14)*
0 upto 50 M
51,000,000 51- to 100M
101,000,000 101 to 300M
301,000,000 301 to 500M
501,000,000 501M to 1 Bn
1,000,000,001 1 Bn +
On Mon, Nov 28, 2011 at 12:35 AM, Aa
Buckets
> 0 upto 50 M
> 51,000,000 51- to 100M
>101,000,000 101 to 300M
>301,000,000 301 to 500M
>501,000,000 501M to 1 Bn
> 1,000,000,001 1 Bn +
First Make table Then Apply below give Vlookup Formula
Instead of Exact Reference(0
Buckets
0 upto 50 M
51,000,000 51- to 100M
101,000,000 101 to 300M
301,000,000 301 to 500M
501,000,000 501M to 1 Bn
1,000,000,001 1 Bn +
add to your table as above and use this
=IF(C4="","",VLOOKUP(C4,$F$9:$G$15,2))
D
=IF(C4="","",VLOOKUP(C4,$F$9:$G$15,2))
and copy down
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Sunday, November 27, 2011 1:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Other possibility
Dear Experts,
I have already write formula to ge
