September 2012 12:37
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA
>
> ** **
>
> Dear Friends,
>
>
>
> Help me to find the circle and area. Please find the attached file for
> your reference.
>
$$ HELP ME TO FIND THE CIRCLE AND AREA
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/discussexcel
FORUM RULES (1120+ members
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
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/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, ac