+ Reply to Thread
Results 1 to 8 of 8

search column A to match reference and return from column B

  1. #1
    Registered User
    Join Date
    02-05-2010
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Thumbs up search column A to match reference and return from column B

    I will appreciate your help to solve the problem as shown in attachment.

    thanks in advance.
    Attached Files Attached Files
    Last edited by canada123; 07-17-2011 at 09:49 AM. Reason: To verify another option

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: search column A to match reference and return from column B

    How about with your sample...

    =VLOOKUP(E13,$B$7:$C$11,2,0)
    HTH
    Regards, Jeff

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: search column A to match reference and return from column B

    I replaced the cell that says "yellow" with a formula, which references A13 containing the value 3 that you are looking for. However, your example workbook does not at all match the title of your thread.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: search column A to match reference and return from column B

    which do you wish to get yellow or 3?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    02-05-2010
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: search column A to match reference and return from column B

    Quote Originally Posted by 6StringJazzer View Post
    I replaced the cell that says "yellow" with a formula, which references A13 containing the value 3 that you are looking for. However, your example workbook does not at all match the title of your thread.
    Great. It works perfect.
    Thanks a lot for your help.

  6. #6
    Registered User
    Join Date
    02-05-2010
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: search column A to match reference and return from column B

    Quote Originally Posted by canada123 View Post
    Great. It works perfect.
    Thanks a lot for your help.
    @Martinwilson,
    Actually i want 3 not the yellow. Please advise.

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: search column A to match reference and return from column B

    Did you try the Vlookup?

  8. #8
    Registered User
    Join Date
    02-05-2010
    Location
    canada
    MS-Off Ver
    Excel 2003
    Posts
    41

    Thumbs up Re: search column A to match reference and return from column B

    Quote Originally Posted by jeffreybrown View Post
    Did you try the Vlookup?
    It worked perfect. Thanks a lot to all who provided different solutions.
    Thanks again.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1