Results 1 to 4 of 4

Thread: Vlookup - Multiple Sheets

  1. #1
    Junior Member
    Join Date
    Jun 2012
    Posts
    10
    Rep Power
    0

    Vlookup - Multiple Sheets

    I have a workbook with daily collection sheets. In Master sheet, I have some bank instruments numbers and amount. I have to find the customers name in Master Sheet. These customers are lying in difference sheets. The title of the sheet are based on date of collection i.e. 01.01.2013 represents collection of 01-Jan-2013


    Please help me to find the customers name without consolidating all collection sheets. I want to write one formula on customers name column which find customers name from all sheets. If one formula not work, then it would be not possible to write 30 formula to find customers from 30 days collection sheet.
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    Please find attached.
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Jun 2012
    Posts
    10
    Rep Power
    0
    Wonderful.

    Thanks

  4. #4
    Junior Member
    Join Date
    Sep 2011
    Posts
    8
    Rep Power
    0
    Great.But i was unable to understand how the formula actually calculates the desired result

Similar Threads

  1. Vlookup to Return Multiple Values
    By Admin in forum Download Center
    Replies: 9
    Last Post: 02-17-2017, 07:03 PM
  2. How do I get Vlookup to return multiple matches?
    By HANOOF in forum Excel Help
    Replies: 1
    Last Post: 06-04-2013, 10:06 PM
  3. Vlookup Multiple Values By Adding Formula With Loop In VBA
    By Safal Shrestha in forum Excel Help
    Replies: 15
    Last Post: 04-22-2013, 04:49 PM
  4. Vlookup with multiple criteria
    By patsir in forum Excel Help
    Replies: 7
    Last Post: 08-27-2012, 11:15 AM
  5. VLOOKUP with Multiple Results
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 05-26-2011, 10:29 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •