+ Reply to Thread
Results 1 to 4 of 4

Formula to search a column for a specific value, and return the value in the next cell

  1. 02-25-2013, 06:45 PM #1
    TimothyD
    TimothyD is offline
    Registered User
    Join Date
    02-25-2013
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula to search a column for a specific value, and return the value in the next cell

    Hi. I'm going to do my best to articulate what I'm trying to do here.

    I have a multi-sheet workbook with data on tab 2 that is set up to populate a yes/no in column A depending on if certain info is input on the first tab (A11:A70) . What I want to do is make it so A73:A175 (on 1st tab) searches for a "yes" in column A of my 2nd tab, and if it finds a "yes", then returns the value to the right. So if I find a "yes" in A1 it will display the value in B1.

    I'm looking to make cells A73:A175 on the first sheet essentially make a list of the values to the right (column B) of every "yes" on the second tab (Potential Docs).

    Can any gurus give me a hand with this?

    I've attached a draft of what I'm working on.

    I can't wait to see how to do this, as I've been messing with different things for a while now.

    Thanks - TD
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-25-2013, 07:24 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Formula to search a column for a specific value, and return the value in the next cell

    See what you think of this:SAMPLE-Closeout Deliverable Checklist.sol1.xlsx

    I had to Un-merge the cells from Row 72 down, and changed the Column headers to make it a single formula rather than 5 different ones

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  3. 02-25-2013, 11:54 PM #3
    TimothyD
    TimothyD is offline
    Registered User
    Join Date
    02-25-2013
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Formula to search a column for a specific value, and return the value in the next cell

    dredwolf you did it! Thanks a lot. Wow that is a complex formula and beyond my skills.

    I find myself more and more in need of more advanced excel skills, do you think my best bet is taking some classes at the local college?
    Reply With QuoteRegister To Reply
  4. 02-26-2013, 12:02 AM #4
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Formula to search a column for a specific value, and return the value in the next cell

    Thank you, and you are welcome!
    Taking classes can only help, as can reading through the solutions presented here and other sites, try out a few of the formulas for your self and see if you can figure them out, and break them down...the evaluate formula tool under the formula tab on the ribbon bar, is an immense help for this ! I use it constantly, especially on some of the more complex formulas...we all get lost sometimes
    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)

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