Re: $$Excel-Macros$$ lagna rising

2012-01-15 Thread Nemi Gandhi
(P3,$B$4:$B$28,0)+4),1)) > > > ** ** > > > *From:* excel-macros@googlegroups.com [mailto: > > excel-macros@googlegroups.com] *On Behalf Of *Nemi Gandhi > > *Sent:* Jan/Fri/2012 03:29 > > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Macros$$

Re: $$Excel-Macros$$ lagna rising

2012-01-13 Thread Sam Mathai Chacko
3,$B$4:$B$28,0)+4 > &":o"&MATCH(P3,$B$4:$B$28,0)+4),1)) > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Nemi Gandhi > *Sent:* Jan/Fri/2012 03:29 > *To:* excel-macros@googlegroups.com > *S

RE: $$Excel-Macros$$ lagna rising

2012-01-13 Thread Rajan_Verma
Try this : =INDEX(C4:N4,MATCH(Q3,INDIRECT("C" & MATCH(P3,$B$4:$B$28,0)+4 &":o"&MATCH(P3,$B$4:$B$28,0)+4),1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nemi Gandhi Sent: Jan/Fri/2012 03:29 To: excel-macros@googlegr

$$Excel-Macros$$ lagna rising

2012-01-13 Thread Nemi Gandhi
Problem in getting result, hence sheet is attached once again. Nem Gandhi -- Nemi Gandhi 98204 92963 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and