On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra <rhtdmja...@gmail.com>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 the all the record that contain singh displayed > > > > > On Sat, Oct 1, 2011 at 12:08 PM, rajan verma <rajanverma1...@gmail.com>wrote: > >> hi.. >> See the attached Sheet... >> Its Done With HlookUp + indirect >> and Other Way By offset() >> >> Regards >> Rajan. >> >> On Sat, Oct 1, 2011 at 8:03 AM, Saurabh Salgotra <rhtdmja...@gmail.com>wrote: >> >>> IN THIS SHEET SEARCHING IS WORKING BUT IT IS LIMITING FOR SEARCHING THE >>> DATA ONLY FROM ONE SHEET(WHICH IS ADDREDSSED IN FORMULA). >>> >>> I WANT TO SEARCH DATA FROM THE SHEET WHICH I HAVE SELECTED IN THE DROP >>> DOWN LIST >>> >>> I MEAN THAT WHICH SHEET IS SELECTED IN DROPDOWN LIST I GOT THE RESULT >>> FROM THAT SHEET. >>> >>> >>> FORMULA IS: >>> >>> >>> =INDEX(JUN12!$A$2:$A$65536,**SMALL(IF(ISNUMBER(SEARCH($C$3,** >>> JUN12!$B$2:$B$65536)),ROW(**JUN12!$B$2:$B$65536)-MIN(ROW(** >>> JUN12!$B$2:$B$65536))+1,""),**ROW(A1))) >>> >>> >>> >>> IN THIS FORMULA I HAVE MENTIONED THE SHEET NAME. >>> >>> SEE DROPDOWNLIST IN D1 I HAVE SELECTED THE SHEET DEC-10, HOW I CAN >>> WRITE THE FORMULA FOR THIS >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > mujhay dukh is baat ka nahin kay meri zaat ko > muntashir karny walay haath tairy thy > mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko > samaitnay walay haath tairy na thy > > > > -------------------------------------------------------------------------------- > > > Thanks & Regards > Sourabh > Contact Numbers: +91-94630-49202 > Website:http://adhurapyaar.co.cc > > > -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy -------------------------------------------------------------------------------- Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
