+ Reply to Thread
Results 1 to 3 of 3

Multi Worksheet, 2 Dimensional Lookups

  1. #1
    Registered User
    Join Date
    02-05-2017
    Location
    New Jersey
    MS-Off Ver
    2017
    Posts
    2

    Multi Worksheet, 2 Dimensional Lookups

    Thank you for your time everyone.
    Attached Files Attached Files
    Last edited by krundes; 02-09-2017 at 11:09 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: Multi Worksheet, 2 Dimensional Lookups

    Not sure if this is what you need ..

    in B2

    =VLOOKUP($A2,INDIRECT("'" & TEXT($G$23,"mmmm") &"'!$A$1:$AJ$54"),MATCH(B$1,INDIRECT("'" &TEXT($G$23,"mmmm") &"'!$A$1:$AJ$1"),0),0)

    Copy across and down

    VLOOKUP in Month tab from date in G23

  3. #3
    Registered User
    Join Date
    02-05-2017
    Location
    New Jersey
    MS-Off Ver
    2017
    Posts
    2

    Re: Multi Worksheet, 2 Dimensional Lookups

    Thank you.
    Last edited by krundes; 02-09-2017 at 11:09 AM.

+ 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. Help converting one-dimensional array to multi-dimensional array
    By puzzlelover22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2016, 06:48 AM
  2. Multi dimensional lookup
    By goblue12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2014, 08:52 AM
  3. [SOLVED] Dim multi dimensional array
    By jdfjab in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-06-2012, 09:08 AM
  4. [SOLVED] Multi Worksheet, 2 Dimensional Lookups - help appreciated!
    By yetirider in forum Excel General
    Replies: 12
    Last Post: 04-03-2012, 03:44 AM
  5. WorkSheet Function with Multi Dimensional Array
    By lopiner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2010, 02:54 PM
  6. [SOLVED] Multi Dimensional Array
    By andym in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2006, 03:29 AM
  7. [SOLVED] Multi-Dimensional Array Let & Get
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-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