+ Reply to Thread
Results 1 to 5 of 5

lookup a single value and return related texts in multiple columns horizontally

Hybrid View

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    15

    lookup a single value and return related texts in multiple columns horizontally

    Hello Everyone

    I'm having a hard time with this one

    Basically I want lookup ATM no. in sheet 2 and return related BRANCH, ZONE ID, and CITY details, horizontally in sheet 1.

    Any help would be appreciated...




    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-20-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    5

    Re: lookup a single value and return related texts in multiple columns horizontally

    In the C2 range, input =VLOOKUP(B2,Sheet2!$A$2:$D$5,2,0). This will automatically input your BRANCH. For your ZONE ID and CITY, input the same formula, but change the 2 after the table range in the vlookup to a 3 and 4, respectively.

  3. #3
    Registered User
    Join Date
    02-09-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: lookup a single value and return related texts in multiple columns horizontally

    multiple-columns-horizontally-lookup.xlsx

    Try this..

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: lookup a single value and return related texts in multiple columns horizontally

    Try this formula in C2. Pull formula to the right and then down

    =VLOOKUP($B2,Sheet2!$A$2:$D$5,COLUMNS($A1:B1),0)
    Last edited by AlKey; 11-20-2014 at 10:59 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: lookup a single value and return related texts in multiple columns horizontally

    hI c2= and drag it down and across..

    Formula: copy to clipboard
    =VLOOKUP($B2,Sheet2!$A$1:Sheet2!$D$5,MATCH(Sheet1!C$1,Sheet2!$A$1:$D$1,0))
    Click just below left if it helps, Boo?ath?

+ 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. lookup a single value and return items in multiple columns
    By FredFitzgerald in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2014, 03:29 PM
  2. Lookup multiple values in different columns and return a single value
    By tanyael in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-18-2014, 10:41 AM
  3. Lookup to return multiple values horizontally
    By ROBMP in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-06-2014, 01:32 PM
  4. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  5. Replies: 2
    Last Post: 08-31-2006, 03: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