Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-06 Thread Ms-Exl-Learner .
Hi Manish, You are welcome!!! and in my previous reply I wrongly mentioned the name as "Bhushan" instead of your name . --- Ms.Exl.Learner --- On Sun, Feb 6, 2011 at 2:38 PM, Manish wrote: > Hey... Gr8... > Thanks for reply... > You all are just Wow !!! !

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-06 Thread Manish
Hey... Gr8... Thanks for reply... You all are just Wow !!! !! Regds, Manish On Feb 6, 2:01 pm, "Ms-Exl-Learner ." wrote: > Hi Bhushan, > > Sumproduct can be used when the result is Numeric Value. > > Have a look in the attached excel for retrieving the text output. > > --- >

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-06 Thread Ms-Exl-Learner .
Hi Bhushan, Sumproduct can be used when the result is Numeric Value. Have a look in the attached excel for retrieving the text output. --- Ms.Exl.Learner --- On Sat, Feb 5, 2011 at 12:09 PM, Manish wrote: > Also Sumproduct is useful for numaric value. >

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-04 Thread Manish
Also Sumproduct is useful for numaric value. Is there any other formula, that will work as SUMPRODUCT for text?? Pls suggest. On Feb 5, 11:05 am, Manish wrote: > Is it possible to hide the complete row based on lookup value?? > For example in your solution, if i lookup value x than i want to hid

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-04 Thread Manish
Is it possible to hide the complete row based on lookup value?? For example in your solution, if i lookup value x than i want to hide row 14 because the lookup result is 0 /Blank. And if i change the value and look the value y i want to hide both row 13 and 14. Simply, I want automtion for hide bl

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-02 Thread ashish koul
@bushan mail your file to id excel-macros@googlegroups.com and attach the file On Wed, Feb 2, 2011 at 4:42 PM, Bhushan wrote: > Hi, > > I am not finding any link from where i can upload my sample file. > > Regards. > Bhushan > > On Feb 2, 2:11 pm, Manish wrote: > > Thanks for valuable post.

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-02 Thread Bhushan
Hi, I am not finding any link from where i can upload my sample file. Regards. Bhushan On Feb 2, 2:11 pm, Manish wrote: > Thanks for valuable post. > Is it possible to hide the complete row based on lookup value?? > For example in your solution, if i lookup value x than i want to hide > row 14

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-02 Thread Manish
Thanks for valuable post. Is it possible to hide the complete row based on lookup value?? For example in your solution, if i lookup value x than i want to hide row 14 because the lookup result is �0�/Blank. And if i change the value and look the value �y� i want to hide both row 13 and 14. pls sug

Re: $$Excel-Macros$$ One lookup and different corresponding values

2011-02-01 Thread Ms-Exl-Learner .
Hi Bhushan, Have a look in the attached files. I never suggest array formula when the same can be done in normal way. HTH :) --- Ms.Exl.Learner --- On Tue, Feb 1, 2011 at 6:22 PM, Bhushan wrote: > Dear Ayush, > > Pls assist me for the below formula. I

$$Excel-Macros$$ One lookup and different corresponding values

2011-02-01 Thread Bhushan
Dear Ayush, Pls assist me for the below formula. I have a huge data from that I have given a sample below for your understanding. I have a data with lookup value with different corresponding values. When I am using the vlookup the vlookup is only taking the one correponding value of that lookup I