--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel
Hi Jai,
Look Attached below..
On Wed, Jul 6, 2011 at 2:19 PM, Jai jaihumtu...@gmail.com wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
*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,
Dear Jai,
Please try it without helping column..
=VLOOKUP(B7*,Sheet1!B7:C12,2,)
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed, Jul 6, 2011 at 2:19 PM, Jai jaihumtu...@gmail.com wrote:
--
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 but
Thanks of Lot Sir
On Wed, Jul 6, 2011 at 3:42 PM, ankur ankurpande...@gmail.com 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
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, 2011 at 3:49
It's great...!!!
*---
кαяαηη*
On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Jai,
Please try it without helping column..
=VLOOKUP(B7*,Sheet1!B7:C12,2,)
Thanks regards,
Noorain Ansari
* 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 Regarding Query