: $$Excel-Macros$$ Lookup problem
Dear Rajan,
I sincerely express my gratitude to you for your kind help and support that
you have extended towards me.
Noorain ,
Your excellent guidance over MS Excel has proved to be of immense help to me
in implementing my work. All the three options
Thanks bro..
On Mon, Jun 25, 2012 at 1:05 PM, Kal xcel wrote:
> Dear Rajan,
>
> I sincerely express my gratitude to you for your kind help and support
> that you have extended towards me.
>
>
> Noorain ,
>
> Your excellent guidance over MS Excel has proved to be of immense help to
> me in implem
Dear Rajan,
I sincerely express my gratitude to you for your kind help and support that
you have extended towards me.
Noorain ,
Your excellent guidance over MS Excel has proved to be of immense help to
me in implementing my work. All the three options that you have taught me
are working smoothl
Dear Kalyan,
Please use..
*=VLOOKUP("*"&MID(B25,7,2)&"*"&C25,$B$2:$C$21,2,0)*
or
*=INDEX($C$2:$C$21,MATCH("*"&MID(B25,7,2)&"*"&C25,B2:B21,0))*
or
*=LOOKUP(2,1/((RIGHT(B2:B21,7)="CE "&C25)),C2:C21)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.co
Use this :
=SUMPRODUCT(--(RIGHT(B2:B21,7)="CE "&C25),C2:C21)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kal xcel
Sent: 22 June 2012 4:27
To: excel-macros@googlegroups.com
Subject: $$Excel-Mac
Dear Kalyan,
Please see attached sheet..Most Probably your problem has
been solved
Thanks,
Noorain
noorain.ans...@gmail.com
9911176564
On Wed, Aug 11, 2010 at 4:26 PM, Kal xcel wrote:
> Hi,
>
> I have this data in a sheet
>
> *Depot Name* *BP Name - Report*
> Ahmedabad H K Sales
Hi Kalyan pls use Pivot table u can see like the date below.
Count of BP Name - Report Depot Name BP Name - Report Total
Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham
Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy
Traders
Chandra,
Please provide a excel 2003 version. I want to learn the solution for
this problem
Harry
On May 11, 5:27 pm, Chandra Gupta wrote:
> Hi
>
> Please find your attached solution.
>
> Thanks
>
>
>
>
>
> On Tue, May 11, 2010 at 4:04 PM, vinu wrote:
> > Hello,
>
> > I have a data in two colu
Hi
Please find your attached solution.
Thanks
On Tue, May 11, 2010 at 4:04 PM, vinu wrote:
> Hello,
>
> I have a data in two colums like
> A 10
> B 20
> A 30
> C 15
> D 20
> B 25
> A 40
>
> If I use Vlookup will get for lookup up value"A" - it will pick up
> corresponding first occurance only
