+ Reply to Thread
Results 1 to 4 of 4

Lookup Text in Row, Return entire (2) columns of Data in another Worksheet

  1. #1
    Registered User
    Join Date
    06-04-2014
    MS-Off Ver
    2013
    Posts
    15

    Lookup Text in Row, Return entire (2) columns of Data in another Worksheet

    I am stumped! It's my first time adding an attachment, let me know if it doesn't work. What I am trying to do is type a drawing name in cell F2 in worksheet "Summary" and the formula search in worksheet "Data" and return the data from the (2) columns that is associated with that drawing into "Summary" D2:E. Any help is appreciated or even a push in the right direction.

    Thanks, Curt
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-09-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Lookup Text in Row, Return entire (2) columns of Data in another Worksheet

    Hi,

    Well I was little confused about the requirement, but see the file.

    Regards,
    Attached Files Attached Files

  3. #3
    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 Text in Row, Return entire (2) columns of Data in another Worksheet

    Hi, May be this for


    D2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    E2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Lookup Text in Row, Return entire (2) columns of Data in another Worksheet

    Like this? I assume the shorts column is always to the right of the dwg column.
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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 and return entire row
    By g1terra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2014, 02:07 PM
  2. using lookup to return full columns of data
    By Akira181 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2010, 08:51 AM
  3. Replies: 1
    Last Post: 02-21-2009, 10:13 PM
  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. entire worksheet of dates in multiple columns to text to be appear as dd/mm/yy
    By alwaysdown in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2007, 10:52 AM

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