Hello Asa,
Thank you for your explanation.
Deba, also hope this website also help you.
http://www.excelfunctions.net/ExcelCellReferences.html
If that works for you, you can avoid LEFT function,
=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&MID(TRIM(D6),2,{1,2,3,4,5,6,7,8,9})&"*",SUBSTITUTE(C$6:C$47,"
uesday, April 03, 2012 10:48 PM
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: Re: $$Excel-Macros$$ Re: Exact names Find
Dear Expert
Can you please explain me the following :-
=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7
,8,9
*Dear Expert
Can you please explain me the following :-
*=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47,"
",""),0),"")))
There i find -C$6:C$47, i mean $ symbol is there . can you please tell
me how the $ symbol arise.
Thank
Great job Haseeb !!!
thank you
chilexcel
2012/4/3 Aamir Shahzad
> Haseeb,
>
> Can you breif your formula if I want to understand the logic.
>
> Regards,
>
> Aamir Shahzad
>
> On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote:
>
>> Hello Deba,
>>
>> Try this in E6 with *CTRL+SHIFT+ENTER*, rath
Haseeb,
Can you breif your formula if I want to understand the logic.
Regards,
Aamir Shahzad
On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote:
> Hello Deba,
>
> Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER
>
> =INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,
You can try this :
=VLOOKUP("*" &D6 &"*",$C$6:$C$47,1,0)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of CoRe
Sent: Apr/Tue/2012 02:41
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: $$Excel-Macros$$ Re: Exact names Find
*Hi All,
Thank you very much experts. Once again thanks.
*
Thanks & Regards,*
*
On Tue, Apr 3, 2012 at 2:41 PM, CoRe wrote:
>
> Hello Bhaity,
>
> PFA.
>
> I used Trim in first instance to loose all the spaces, 2nd thing ID
> collumn has been sort as ascending for a better match. (descend
