RE: $$Excel-Macros$$ Vlookup Regarding Query Please Help

"*" Character will find the value which start with Following Characters. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Wednesday, July 06, 2011 4:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Regar

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

THIS Realy Good Formula Thaks On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* >

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

It's great...!!! *--- кαяαηη* On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Very intelligent solution by Noorain.. Jai, I am giving another solution =VLOOKUP(IF(FIND(B17,Sheet1!B5,1),"*"&B17&"*",0),Sheet1!$B$5:$C$10,2,0) Try this, it will search "RAM" or "ROH" in total string and show result. "RAM or "ROH" could be anywhere in the string. On Wed, Jul 6, 201

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Thanks of Lot Sir On Wed, Jul 6, 2011 at 3:42 PM, ankur wrote: > *hi jai > find the attached filethis has slight modification of venkatesan > solution...the repeat of name is taken care , as u required tell me it > helps? > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pa

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

hi Noorain Ansari very good formula.can u explain me what "*" had make difference in this formula. use of "*" in formula had done what magic..i will also use this in other formulas in future Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best bu

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Dear Jai, Please try it without helping column.. =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > ---

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

*hi jai find the attached filethis has slight modification of venkatesan solution...the repeat of name is taken care , as u required tell me it helps? *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6,

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Hi Jai, Look Attached below.. On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailyti