+ Reply to Thread
Results 1 to 4 of 4

Lookup and return entire row

  1. #1
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Lookup and return entire row

    What is the best formula to lookup and name in a column and return the entire row if the lookup name is in the 3rd column?

  2. #2
    Forum Contributor Cerbera's Avatar
    Join Date
    07-06-2010
    Location
    Rotorua, New Zealand
    MS-Off Ver
    Excel 2007, 2013, 2016 & 365
    Posts
    137

    Re: Lookup and return entire row

    Probably be best to submit a sample spreadsheet so that we can see the layout, i.e. where is the row to be returned? Also do you want to return the row number or the data from that row?

    If it's the data from the relevant row you're probably best using a macro, otherwise you'd have to copy the formula across the entire row used to output the data from the original.
    If I've helped please click on *Add Reputation

  3. #3
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Lookup and return entire row

    Yes, g1terra..
    need more info..
    A sample non sensitive workbook will do..
    You can also refer INDEX MATCH for it..


    Regards,
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  4. #4
    Forum Contributor
    Join Date
    10-16-2014
    Location
    Center Line, Michigan, United States
    MS-Off Ver
    MS Office 2013
    Posts
    139

    Re: Lookup and return entire row

    Hello g1terra welcome to the forum!

    Your answer will depend if you want the results in multiple columns or just one. I took the liberty of making two different formulas to handle each situation.

    LookupEntireRow.xlsx
    Please click the star (add rep) if I helped!

+ 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 for a cell value in entire sheet and return value from a column
    By atulkumar.goel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2014, 01:38 PM
  2. Search an entire column for a value, return entire row.
    By jdsmith1895 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 12:53 PM
  3. Search entire column, return entire row
    By Chris Gwynne in forum Excel General
    Replies: 0
    Last Post: 08-04-2011, 11:21 AM
  4. Lookup Value in Column return entire row
    By Soybean in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2008, 07:40 PM
  5. [SOLVED] How do I return entire rows in a lookup of one sheet to another?
    By dflohn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2005, 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