:* Monday, May 21, 2012 11:27 PM
>
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
> sorry not understand make it clear, lots of expert here can solve your
> issue.
>
> Aamir Shahzad
> On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD
> wrote:
>
> Hi Aami
gt; I know
>
> Hi, Anil,
>
> I know that, but as per my condition or requirement, if first five number
> (from left) and first name (in any case upper of lower) should be match.
> subsidary sheet in A17 is
>10020-16A-BLKC-MR. ANUPAM SARKAR
> and in sheet2 in A17 is
>10
)
,Sheet2!$A$2:$C$7493,3,0)
Sheet2!$A$2:$C$7493--?
Thanks & Regards
LAKSHMAN
From: Aamir Shahzad
To: excel-macros@googlegroups.com
Sent: Sunday, May 20, 2012 8:33 PM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
As desired by you, see the attached file.
Aamir Sha
; *From:* Anil Gawli
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, May 18, 2012 6:22 PM
>
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
> **
> subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in
> sheet2 in A17 is 10020--BLKC-MR. AN
(2)
From: Anil Gawli
To: excel-macros@googlegroups.com
Sent: Friday, May 18, 2012 6:22 PM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
subsidary sheet in A17 is
10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2 in A17 is
10020--BLKC-MR
May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD
> wrote:
>
>> Hi Anil,
>>
>> Plz see cell D13 and D17 value or #NA data no coming
>>
>>
>>
>>
>> *From:* Anil Gawli
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Friday, May 18, 2012 5
A data no coming
>
>
>
>
> *From:* Anil Gawli
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, May 18, 2012 5:37 PM
> *Subject:* Re: $$Excel-Macros$$ unable to use advance vlookup
>
> Try this see attached file
>
> On Fri, May 18, 2012 at 4:36 PM, LAKSHM
Hi Anil,
Plz see cell D13 and D17 value or #NA data no coming
From: Anil Gawli
To: excel-macros@googlegroups.com
Sent: Friday, May 18, 2012 5:37 PM
Subject: Re: $$Excel-Macros$$ unable to use advance vlookup
Try this see attached file
On Fri, May
