+ Reply to Thread
Results 1 to 5 of 5

Multiple Lookup Sheets

  1. #1
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    218

    Question Multiple Lookup Sheets

    Good Day

    I have an excel sheet witk Sheet "MAIN". On this sheet Range A1 I put in an "Item Code". I have Over 55000 Item Codes. On the same workbook I have 30 Other sheets with Data tables from SQL SERVER. I use the Item Code(s) on Sheet Main to find the data in the other SHEETS. The First 2 Letters in my Item Code tells me where to go find the rest of the data about that specific Item.

    My problem is that I don't want to go create a vlookup with 30 arguments. Is there another way that I can refer to the First 2 letters of the Itemcode? ie
    Please Login or Register  to view this content.
    Thanks
    Last edited by Sniper; 03-16-2014 at 06:20 AM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,039

    Re: Multiple Lookup Sheets

    Hi, Sniper,

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

    You would not only need to pass the information of the sheetname but of the range as well so this should be adjusted if needed.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    218

    Re: Multiple Lookup Sheets

    Thanks for the reply, if I do a normal VLOOKUP it looks like this:
    Please Login or Register  to view this content.
    Should it then be something like:
    Please Login or Register  to view this content.
    Thanks

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,039

    Re: Multiple Lookup Sheets

    Hi, Sniper,

    without showing your workbook only you may anwer this question. If you have given names to the used ranges in the sheets you may only pass the name of the sheet/range, if its not the case you should pass the ranges where to search as well.

    Ciao,
    Holger

  5. #5
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    218

    Re: Multiple Lookup Sheets

    Thanks HaHoBe

    It's working 100% Now. You saved me HOURS of work.

    Thanks

+ 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. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  2. Lookup and return multiple matches across multiple sheets
    By somnath6309 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2013, 02:44 AM
  3. Lookup and return multiple matches across multiple sheets
    By somnath6309 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2013, 03:45 PM
  4. 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
  5. [SOLVED] Multiple lookup query, AND/IF multiple sheets
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-29-2012, 09:01 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1