+ Reply to Thread
Results 1 to 3 of 3

Look up values in 2 adjacent columns. Return values in 3 columns if match.

  1. #1
    Registered User
    Join Date
    09-24-2015
    Location
    PA
    MS-Off Ver
    2013
    Posts
    11

    Look up values in 2 adjacent columns. Return values in 3 columns if match.

    Hello!

    In column A and B I have values. I need a formula that can look at column A and column B and find certain values I specify. For example, I need the formula to find "2" in column A and "1948" in column B. Once it finds those values I would like it to return values I specify to 3 different adjacent cells. For example, the formula finds "2" and "1948" in cells A2 and B2. It then returns "1" to cell D2, "2" to cell E2, and "3" to cell F2.

    Any help is greatly appreciated. Thanks! Lookup Multiple Columns.xlsx

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Look up values in 2 adjacent columns. Return values in 3 columns if match.

    Hi
    Use this array formula in D2:F2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    where $H$1 and $I$1 have your data search
    copy down
    Last edited by José Augusto; 11-04-2015 at 12:21 PM.

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Look up values in 2 adjacent columns. Return values in 3 columns if match.

    What do you want it to return to D2, E2, and F2 if the combination is not found? Will the searched for values always be 2 and 1948, or could that change to lets say, 5 and 616

    Any problems using a helper column?

    Pete

+ 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. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  2. Replies: 3
    Last Post: 02-15-2012, 01:18 AM
  3. Match values in 2 columns and return the sum
    By Shaz_79 in forum Excel General
    Replies: 5
    Last Post: 01-08-2012, 10:33 AM
  4. match all two columns and return third values
    By excelkeechak in forum Excel General
    Replies: 13
    Last Post: 04-13-2011, 09:00 AM
  5. Match Columns in 2 Worksheets, return only changed values of other columns
    By cheynooki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2011, 01:19 PM
  6. Compare values in two columns and return text from adjacent cell
    By MrBorders in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2009, 04:54 AM
  7. Replies: 5
    Last Post: 10-11-2008, 04:01 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