Ok I even managed to modify this so that the "source" can go upto 1000
lines of "match" info (or more should I require it). This is a very
powerful template that I can see multiple applications for. Thank You Very
Much Kantila. MUCH appreciated !
On Wednesday, November 13, 2013 11:22
PFA with range changed from 23rd to 100th lines. It is working fine.
Alternatively you can use named range to make it more easy (Solution
Attached )
As far as benefits / limitations are concerned array solutions are very
powerful compared to non array. But I personally prefer array solutions
only
Kantila,
Thanks for your effort. I appreciate it and everyone else's contribution. I
have a question
I want to add to this. So, I looked at the code and notice that you have
defined everything to end at line 23 (except for the last past that says
22?). That's fine, I thought I could cha
PFA
Non array solution
CA Kantilal Badale
On Tue, Nov 12, 2013 at 7:33 AM, Bill Q wrote:
> PERECT Ravinder !
>
> MANY thanks !
>
>
> On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
>
>> pfa
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
> pfa
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Bill Q
> *Sent:* Sunday, November 10, 2013 10:55 PM
> *To:* excel-...@googlegroups.co
Thanks Bruce
On Monday, 11 November 2013 19:51:30 UTC-5, bruce wrote:
> What is PFA?PFA is "Please Find Attached"
> On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
>>
>> What does pfa mean ?
>>
>>
>> On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
>>
>>> pf
What is PFA?PFA is "Please Find Attached"
On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
>
> What does pfa mean ?
>
>
> On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
>
>> pfa
>>
>>
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com]
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
> pfa
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Bill Q
> *Sent:* Sunday, November 10, 2013 10:55 PM
> *To:* excel-...@googlegroups.com
> *Subject
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Sunday, November 10, 2013 10:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup - Price List
Hi Guys,
This seems simple and I am pretty certain that it is - b
