+ Reply to Thread
Results 1 to 4 of 4

Formula Find Specified Text show contents of the cell below

  1. 02-15-2014, 10:25 PM #1
    keen2xl
    keen2xl is offline
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Red face Formula Find Specified Text show contents of the cell below

    Hi Dudes

    Formula to find any specified text show contents of the cell directly below

    Experiment sheet attached

    Dats it

    Cheers You Da men
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-16-2014, 07:08 AM #2
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Formula Find Specified Text show contents of the cell below

    I don't understand what you want. Could you fill out the workbook with some sample data and sample of what you want to achieve?
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  3. 02-16-2014, 07:25 AM #3
    keen2xl
    keen2xl is offline
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: Formula Find Specified Text show contents of the cell below

    Hi Jacc

    Was doing a more detailed example and did a quick search for Offset example and found my answer ha

    It is


    =INDEX(B:B,MATCH(" Account",B:B,0)+1)


    Thanks though

    Cheers
    Reply With QuoteRegister To Reply
  4. 02-21-2014, 04:43 PM #4
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Formula Find Specified Text show contents of the cell below

    Thanks for posting the solution you found!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ctrl + J to find and replace Alt + Enter in multi line cell contents or Text to Columns
    By newdoverman in forum Tips and Tutorials
    Replies: 0
    Last Post: 02-01-2014, 09:52 AM
  2. [SOLVED] Macro to copy cell contents then used Find & Replace to put text elswhere.
    By AimeeNZ in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2012, 01:06 AM
  3. Find all repititions of contents of cell within a text column
    By blessing in forum Excel General
    Replies: 7
    Last Post: 04-08-2011, 01:31 PM
  4. Find cell based on formula result and delete contents
    By Big Chris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2006, 10:07 AM
  5. Excel formula to find position of the contents of a cell within a column.
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 09-26-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1