RE: $$Excel-Macros$$ Lookup problem

: $$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

Re: $$Excel-Macros$$ Lookup problem

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

Re: $$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 that you have taught me are working smoothl

Re: $$Excel-Macros$$ Lookup problem

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

RE: $$Excel-Macros$$ Lookup problem

bject: $$Excel-Macros$$ Lookup problem Dear Experts, Please help me to solve my query. Details is in attached sheet. -- Kalyan Chattopadhyay Executive Sales Coordinator R. S. H. Pvt. Ltd. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate threa

$$Excel-Macros$$ Lookup problem

Dear Experts, Please help me to solve my query. Details is in attached sheet. -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please He

Re: $$Excel-Macros$$ Lookup Problem

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

Re: $$Excel-Macros$$ Lookup Problem

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

$$Excel-Macros$$ Lookup Problem

Hi, I have this data in a sheet *Depot Name* *BP Name - Report* Ahmedabad H K Sales Agency - Sanand Ahmedabad Parshwa Traders - Gandhinagar Ahmedabad Soham Agency - Chikhli Ambala Chaman Traders - Ambala Ambala Shiv Trading Company - Assandh Ambala Happy Traders - Barara Ambala R. K. Gene

Re: $$Excel-Macros$$ Lookup problem

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

Re: $$Excel-Macros$$ Lookup problem

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

$$Excel-Macros$$ Lookup problem

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 ie,10,10,10 instead of 10,30,40 If I need10,30,40 like this how do I get it? Regards, Vinu. -- -