thanks a lot Noorain
this is what I was looking for
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, May 28, 2012 9:19 AM
Subject: Re: $$Excel-Macros$$ problem with indirect function
On Mon, May 28, 2012 at 1:48 PM, NOORAIN
On Mon, May 28, 2012 at 1:48 PM, NOORAIN ANSARI wrote:
> Dear Pawel,
>
> Please try this one.
>
> =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE)
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On M
Dear Pawel,
Please try this one.
=INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE)
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote:
> Dear All,
> I have prob
u can use vlookup ...
Regards,
Anil Gawli
On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote:
> Dear All,
> I have problem with indirect function in this case is working fine (see
> attachment), but if you can show me some extra features I'll be appreciated.
> Regards,
> Pawel
>
> --
> FORUM