Dear Sundarvelan,
You can try this.
=INDEX($B$2:$B$20,MATCH(K2,$D$2:$D$20,0),1) Paste it I2 &
Ctrl+Shift+Enter.
=INDEX($C$2:$C$20,MATCH(K2,$D$2:$D$20,0),1) Paste it J2 &
Ctrl+Shift+Enter.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 6:46 PM, Rajan_Verma wrote:
> *=INDEX($B$1:$F$20,MATCH(
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 06 September 2012 12:37
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HELP
Dear Sundar,
You can use single Vlookup for both required Column
*=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0)
*
with ctrl+shift+enter
See attached sheet for more clarity.
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Help me to find the
PFA
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Help me to find the circle and area. Please find the attached file for
> your reference.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexc
