On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
thanks for help
but in this sheet all the data returned from the selected sheet searching
not working.
i want 2 solutions
1 choose sheet
2 search data (which is in c3 cols) if u type singh in c3 then result
not working
On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.comwrote:
USE
Well, I haven't used error handler in the first post, but if you use one of
the formulas from my second post, you will not get that #NUM error. Check
the attached file in my previous post.
Sam
On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
VERY VERY THANKS SIR FOR
I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS
. SO THAT'S WHY I WANT ERROR HANDLER ON THIS
On Sat, Oct 1, 2011 at 10:18 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Well, I haven't used error handler in the first post, but if you use one of
the formulas from my
Shorter one...
very very thanks sir for helping me.
On 10/1/11, Sam Mathai Chacko samde...@gmail.com wrote:
Shorter one...
USE
=INDEX(INDIRECT(TEXT(D1,MMMYY)!$A$2:$A$65536),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))),ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))-MIN(ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536)))+1,),ROW(A1)))
in B8
Regards
Sam Mathai Chacko (GL)
On Sat, Oct 1, 2011 at 8:03