+ Reply to Thread
Results 1 to 3 of 3

VLookup with variable table data

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,377

    VLookup with variable table data

    Hello:

    Please refer to attached file.
    I need Formula in Cell C5 to look for ID from column 3 of Store1,2 or 3 sheet for Sku# entered in cell C3.
    Data Table name for each store is listed in cell N1:N3

    I have manually done as shown.

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: VLookup with variable table data

    With over 4000 posts, I'm sure that you must be able to write a single vlookup formula, all you need to do is create that formula 3 times, once for each sheet, then nest them together with iferror
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Use proper ranges in the formula, you don't need to use INDIRECT references with the names in N1:N3, that is an unnecessary step that will cause slower calculation.

    That's as much as I can do without looking at your sample file and I will not open workbooks with a .xlsb file extension.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,377

    Re: VLookup with variable table data

    Hello:
    To make it simple i used as below:

    Please Login or Register  to view this content.
    It works.

    R

+ 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. Formula Help: Vlookup with variable table array based on cell value
    By mincus13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2017, 09:48 AM
  2. VLOOKUP with variable table array using INDIRECT and OFFSET
    By jbrizbee21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2015, 01:29 PM
  3. Variable Table Array VLookup
    By cossie2k in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2015, 06:23 AM
  4. [SOLVED] VLOOKUP to return value from table dependent on 2 variable fields/values
    By ndtsteve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 09:44 AM
  5. Variable File Reference and Variable Table Array in VBA VLOOKUP
    By Gingeiko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 11:08 PM
  6. Excel 2007 : Variable Table Array in VLOOKUP
    By andrewryan in forum Excel General
    Replies: 7
    Last Post: 08-26-2011, 01:28 PM
  7. [SOLVED] Variable table array name in VLOOKUP
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2005, 04:05 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