+ Reply to Thread
Results 1 to 3 of 3

Lookup and return multiple matches across multiple sheets

  1. 09-06-2013, 01:53 PM #1
    somnath6309
    somnath6309 is offline
    Registered User
    Join Date
    09-05-2013
    Location
    Kolkata, Westbengal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Exclamation Lookup and return multiple matches across multiple sheets

    Dear Sir/ Madam,

    How to lookup and return multiple matches across multiple sheets? Vide my attachment.

    Sheet1, 2 & 3 contains tables that are to be looked up.

    Sheet 4 holds amount Rs. Col that present in all the sheets. The Yellow part of the Sheet4 requires a formula that will disclose all the information of the sheets.

    Regards,

    Somanth
    Attached Files Attached Files
    Last edited by JBeaucaire; 09-06-2013 at 06:52 PM. Reason: Email address removed, all answers will be posted here in this thread.
    Reply With QuoteRegister To Reply
  2. 09-06-2013, 02:16 PM #2
    swhitesell
    swhitesell is offline
    Registered User
    Join Date
    10-25-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Lookup and return multiple matches across multiple sheets

    I have no idea what you are trying to do here. Please include a sample sheet with the desired results. This may allow us to provide an answer to your problem.
    Reply With QuoteRegister To Reply
  3. 09-06-2013, 03:45 PM #3
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Lookup and return multiple matches across multiple sheets

    For the let say bill number do you need three in the same cell?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    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. [SOLVED] Lookup and Return Multiple Matches
    By TroyDawes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2013, 10:00 PM
  2. lookup one value over multiple sheets & return multiple responses
    By rsagar-patt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2012, 11:30 AM
  3. Macro using VLOOKUP with multiple matches between multiple sheets
    By Derrek0204 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2011, 06:20 PM
  4. Excel lookup for to return multiple approximate matches
    By nhuang in forum Excel General
    Replies: 5
    Last Post: 02-08-2011, 09:07 AM
  5. [SOLVED] How do I use lookup to return multiple matches and sum them?
    By Nat in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 01:25 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