very very thanks sir for helping me.
On 10/1/11, Sam Mathai Chacko wrote:
> Shorter one...
>
> =IF(ROW($A1)>COUNTIF(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"),"*"&$C$3&"*"),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMM
Shorter one...
=IF(ROW($A1)>COUNTIF(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"),"*"&$C$3&"*"),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(RO
Interesting!!!
Here you go...
=IF(ISERROR(SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9")))+1,""),ROW(A1))),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"
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 wrote:
> Well, I haven't used error handler in the first post, but if you use one of
> the formulas from my second post, you w
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 wrote:
> VERY VERY THANKS SIR FOR HELPING ME I HAVE O
By the way, replace "SINGH" with $C$3
On Sat, Oct 1, 2011 at 4:14 PM, Sam Mathai Chacko wrote:
> Don't seem like you tried my suggestion.
>
> Anyway, since there were posts sharing two examples with HLOOKUP and
> OFFSET, I have included that also in my suggestion.
>
> HLOOKUP and OFFSET will work
not working
On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko wrote:
> 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$
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra wrote:
> 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
> generated t
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,
