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
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:40
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Bill Q
*Sent:* Sunday, November 10, 2013 10:55 PM
*To:*
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] *On
Behalf Of
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:
pfa
*From:*
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Bill Q
*Sent:* Sunday, November 10, 2013 10:55 PM
*To:*
PFA
Non array solution
CA Kantilal Badale
On Tue, Nov 12, 2013 at 7:33 AM, Bill Q ronsmith...@gmail.com wrote:
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com
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
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 -