Dear Satish,
Please try with ctrl+shift+Enter
=INDEX($N$4:$S$10,MATCH(E$4,$M$4:$M$10,0),MATCH($D7,$N$3:$S$3,0))
See attached sheet..
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 22, 2012 at 11:11 PM, satish pn wrote:
> Mr. Rajan Verma
>
Hello Satish,
One way is VLOOKUP
E5, then copy down & across.
=IFERROR(VLOOKUP(E$4,$M$4:$S$10,MATCH($D5,$M$3:$S$3,0),0),"")
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 11:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should lead to change in
all related cells
Mr. Rajan Verma
Please find attached excel file for a
gt; *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *satish pn
> *Sent:* 22 May 2012 11:11
> *To:* excel-macros@googlegroups.com
> *Subject
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Change in one Cell should lead to change in
all related cells
Mr. Rajan Verma
Please find attached excel file for a small example.
On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma
wrote:
Please send some sample data in Excel Worksheet
Mr. Rajan Verma
Please find attached excel file for a small example.
On Tue, May 22, 2012 at 9:10 PM, Rajan_Verma wrote:
> Please send some sample data in Excel Worksheet
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@goog
Please send some sample data in Excel Worksheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish pn
Sent: 22 May 2012 8:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change in o
