+ Reply to Thread
Results 1 to 8 of 8

Search data in one Column, display data from lower down the same column.

  1. #1
    Registered User
    Join Date
    10-08-2015
    Location
    Chesterfield
    MS-Off Ver
    MSO 2013
    Posts
    4

    Search data in one Column, display data from lower down the same column.

    Hi all,
    i am trying to crease an automatically updating workboard for work. i have a fiarly good idea how i want the foramt but i am just struggling puting it into practice. i would like to seach an a column for a name and then display data from cells below. The problem is that this data cannot be fixed, the location of the name will change daily depending on where the men areworking.

    So i want able to search column A for names, by typing (For example keith) in C3, and in D3 it display information from 2 cells below wherever keith appearing in Column A.

    i would like to add a picture for reference to my worksheet but im also new t the forum and not sure how i would do it.

    Thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Search data in one Column, display data from lower down the same column.

    This should be easy enough to accomplish. Upload a sanitized sample file reflecting your desired outcomes. At the bottom right corner of the message box, click on 'Go Advanced', which is between the 'Post Quick Reply' and 'Cancel' buttons. On the next page at the top of the message box find the icon of a paperclip and click on it. Select the sample file and upload it.

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Search data in one Column, display data from lower down the same column.

    Try

    =INDEX(A$3:A$102,MATCH("Keith",A$1:A$100,0))

    Notice the 2 row offset of the 2 referenced ranges.

  4. #4
    Registered User
    Join Date
    10-08-2015
    Location
    Chesterfield
    MS-Off Ver
    MSO 2013
    Posts
    4

    Re: Search data in one Column, display data from lower down the same column.

    Thanks for thye Reply. I havd done as you instructed and uploaded a small sample of my Worksheet.

    what im after is as you update the table on the left information from there is automatically added to the one on the right. as i said before the engeneers names will not be static, they will move around so i need a formula that
    will search colum A and then input the data below it into the table on the right. ie, the site where kieth is working is minworth so as keith is added to the board on the left, it updates the job hes on, site hes on and job number accordingly.

    again, thank your for your help.
    Attached Files Attached Files

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Search data in one Column, display data from lower down the same column.

    It would be very helpful if you put the name in C3 exactly as it would appear in column A.
    You just had Kieth in C3, but A2 shows a full name (with Keith spelled differently).

    Anyway, once you have the correct name in C3
    D3: =INDEX($A$3:$A$13,MATCH($C3,$A$2:$A$12,0)) <- notice the row offset in the 2 ranges.
    E3: =INDEX($A$5:$A$15,MATCH($C3,$A$2:$A$12,0))
    F3: =INDEX($A$4:$A$14,MATCH($C3,$A$2:$A$12,0))

    Then fill all 3 down.

  6. #6
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Search data in one Column, display data from lower down the same column.

    Alternative solution using helper column.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-08-2015
    Location
    Chesterfield
    MS-Off Ver
    MSO 2013
    Posts
    4

    Re: Search data in one Column, display data from lower down the same column.

    Thanks for this, worked Perfectly!!

    now to complicate things even more can you help out with times when there is more than one man on each job? please see second sample for reference.

    notice that Andrew Smith and Keith are now on the Same Job and require the same information to be displayed? there names could be put in the same cell tho save merging if necessary?

    thanks again
    Attached Files Attached Files
    Last edited by MAtt1207; 10-08-2015 at 09:43 AM.

  8. #8
    Registered User
    Join Date
    10-08-2015
    Location
    Chesterfield
    MS-Off Ver
    MSO 2013
    Posts
    4

    Re: Search data in one Column, display data from lower down the same column.

    Please see the Sample attached.

    i need it so multiple men can be put onto the same job and the relevant information be extrcated as such. I have set up two potential methods of displaying this but i cannot get the formulea to work, i was wondering if you had any ideas?

    thanks again.

    Matt
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-30-2015, 01:02 PM
  2. [SOLVED] Formula Generation: Search column range, display cell from different column.
    By Old4xford in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2014, 11:30 AM
  3. Search a column for 2 conditions and display the cell content of last match
    By ansridhar in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-17-2014, 06:41 AM
  4. macro to search a column and display all of the related data
    By dare2join in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2013, 05:36 AM
  5. Array search - display project data and column number for further indexing
    By zenqueth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2012, 07:26 AM
  6. Replies: 3
    Last Post: 12-09-2008, 10:40 PM
  7. Replies: 3
    Last Post: 11-27-2008, 10:06 PM

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