Hi Tom,
Check the attached file and let me know if you face any challenge(s).
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Apr 9, 2010 at 4:36 AM, tomfabtas...@hotmail.com <
tomfa
Hi Tom,
Since you only seem to have 2 ranges, you could just name them, then use the
names in your formulas.
Regards - Dave
> Date: Thu, 8 Apr 2010 16:06:06 -0700
> Subject: $$Excel-Macros$$ MATCH question
> From: tomfabtas...@hotmail.com
> To: excel-macros@googlegroups
Hi,
In an excel worksheet, I have the below formulas in three different
cells. Is there a way to replace the SR_P1!$1:$1, SR_P2!$1:$1, SR_P3!
$1:$1 parts of the function by referencing another cell (maybe using
the address function, or similar) ?
MATCH($A15&D$47, SR_P1!$1:$1, 0)
MATCH($A15&D$47,
