Results 1 to 6 of 6

Return cell contents on a partial match

Threaded View

rhani111 Return cell contents on a... 01-23-2008, 10:26 PM
mikerickson You could use AutoFilter with... 01-23-2008, 11:39 PM
rhani111 Thank you for your speedy... 01-23-2008, 11:48 PM
mikerickson In sheet Canberra, use this... 01-24-2008, 12:33 AM
rhani111 Thank you again...however it... 01-30-2008, 01:08 AM
rhani111 Is there anyone that has a... 02-04-2008, 12:13 AM
  1. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    In sheet Canberra, use this formula in all cells in columns A:F.

    =INDEX(Data!$A:$F,SMALL((100-(99*--(SEARCH("canberra",Data!$A$1:$A$200&"canberra")<LEN(Data!$A$1:$A$200))))*ROW(Data!$A$1:$A$200),ROW()),COLUMN())

    Change the two constant strings to "sydney" for the other sheet, as in the attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1