+ Reply to Thread
Results 1 to 14 of 14

retun existed entire row in another desired cell

  1. 07-17-2013, 02:40 AM #1
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Smile retun existed entire row in another desired cell

    Hi...!
    I'm new to this forum
    I have one filled data table in excel, while I entered desired row number then that entire row will be displayed.
    For this requirement I used " =VLOOKUP($D$2,Table,COLUMN(B1),FALSE) " (without quotes).

    but I'm getting only one row... If I change that row Id that not will be effected

    Thanks in Advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-17-2013, 02:49 AM #2
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    Will work fine..

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


    In you Desired table "Bolt " is with a space.. and you are searching "BOLT" withoout space..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  3. 07-17-2013, 03:02 AM #3
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: retun existed entire row in another desired cell

    Thank u .. thank u very much Mr.Debraj Roy...
    It works fine...
    Reply With QuoteRegister To Reply
  4. 07-17-2013, 03:57 AM #4
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Post Shall we return entire row at any cell in work sheet using vlookup?

    Hi..
    Shall we return entire row at our desired cell/work sheet using vlookup formula?

    suppose in Book3.xls i used vlookup formula for return entire row at the top of the table.It works fine.
    Now I want to return entire row (Book2.xls) at bottom of the table..But I didn't get it.

    Help me please...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-17-2013, 04:14 AM #5
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    Set The table properly.. so that it include Search data column aslo..
    Instead of =Sheet1!$C$3:$H$12 set Table as =Sheet1!$B$3:$H$12
    Reply With QuoteRegister To Reply
  6. 07-17-2013, 04:37 AM #6
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: retun existed entire row in another desired cell

    Mr.Debraj Roy... Its fine but when try this formula (Instead of =Sheet1!$C$3:$H$12 set Table as =Sheet1!$B$3:$H$12 ) in Book3.xls I'm getting #VALUE! error.
    Reply With QuoteRegister To Reply
  7. 07-17-2013, 05:01 AM #7
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    You cant set same NAME twice in a workbook..
    You have already a table named TABLE in the same book.
    Try to create another table with Name as TABLE2, and check..
    Reply With QuoteRegister To Reply
  8. 07-18-2013, 01:23 AM #8
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Post Retrieving to desired entire row data by clicking the combo box

    Hi to all...!!

    I have retrive_row.xls file. In this worksheet , sheet1 having list of data, sheet2 having combo box for retrieving row data.

    Suppose in sheet2,If I choose "ISBM500" in combo box list then that corresponding entire row data will display beside the cells of the combo box

    I don't have any idea...
    help me please......
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 07-18-2013, 01:57 AM #9
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    Hi!

    Please check the attached..

    DropDown Control has a Cell Link Option.. Which track, what you have choose from the dropdown..
    You can user this to display your data.

    D2:J2 has an Array Formula as below
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Attachment 251053
    Reply With QuoteRegister To Reply
  10. 07-18-2013, 02:09 AM #10
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: retun existed entire row in another desired cell

    Oh...great....!!!!
    Its working well...

    Thank you very much Mr.Debraj Roy...
    Thank you for quick reply and i'm getting valuable information..
    Reply With QuoteRegister To Reply
  11. 07-18-2013, 03:43 AM #11
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Choose Row data from combo box for rwtrieved entire row data

    Hi ... ! Mr.Debraj Roy
    U have clarified my doubt on previous thread through the attached file.
    Its working well..
    But I need more information on it.
    If I take another data in sheet1 and retrieve from combo box in sheet2 using index formula...
    but I didn't get values...

    check my attached file...

    so can u describe that formula please?

    I used formula is " =INDEX(Sheet1!$C$15:$I$24,Sheet2!D4,COLUMN(1:6))"

    please evaluate the answer...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 07-18-2013, 03:52 AM #12
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    OK.. you are facing problem in applying Formula.

    Try This..

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

    and drag Rightward..
    Reply With QuoteRegister To Reply
  13. 07-18-2013, 03:54 AM #13
    m1h5s8
    m1h5s8 is offline
    Registered User
    Join Date
    07-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: retun existed entire row in another desired cell

    I have a little bit confusion about column number....
    how should be specify that number?
    Reply With QuoteRegister To Reply
  14. 07-18-2013, 04:10 AM #14
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: retun existed entire row in another desired cell

    In your indexing section Sheet1!$C$15:$I$24 C column is (Column 1) and D is Column 2, and so on.. upto Column I is 6..

    You can specify that bu Number also..

    =INDEX(Sheet1!$C$15:$I$24,Sheet2!$D$4,2)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help to setup restriction (countries) on an already existed VBA
    By siulonbow in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-30-2010, 05:19 AM
  2. Excel Features you wish Existed
    By squiggler47 in forum The Water Cooler
    Replies: 14
    Last Post: 07-15-2009, 09:55 AM
  3. How do you write a formula that will retun a blank cell instead of Zero
    By Slint in forum Excel General
    Replies: 12
    Last Post: 03-02-2009, 04:36 PM
  4. Which function to check any value existed withing a list?
    By Eric in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2005, 08:40 PM
  5. Which function to check any value existed withing a list?
    By Eric in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 08:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1