Results 1 to 4 of 4

Thread: Vlookup - Multiple Sheets

Threaded View

Previous Post Previous Post   Next Post Next Post
  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

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
  •