Results 1 to 4 of 4

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

Threaded View

  1. #1
    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

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