Results 1 to 10 of 10

Dashboard Sheet using Index,Match,Offset function to retrieve Data from another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2021
    Posts
    273

    Dashboard Sheet using Index,Match,Offset function to retrieve Data from another sheet

    Excel Version 2003

    I've workbook containing two sheets, Input, and Output.

    Output sheet - Based on combination of criteria in INPUT cell in Cells A2, B2, and C2, Range in A5:G10 should be filled taking data from Sheet!Input

    Sheet Input, has 6 set of data (rowwise) for each combination of [A2+B2+C2] sorted on column O (datewise) in Sheet!Input

    Currently, I've manually linked the data to illustrate, how the output should look like. If we change the combination in cells [A2+B2+C2] , output range A5:G10 should change accordingly.

    How to make use of Vlookup,Index,Match, Offset function to get the desired output.

    Sample file is attached for easy reference.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to perform an index/match function to retrieve data
    By mji006 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-07-2014, 04:23 PM
  2. Issue with using Index Match function to return value from Summary Sheet
    By missmea2005 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2013, 02:02 PM
  3. Replies: 2
    Last Post: 01-14-2013, 06:30 AM
  4. Replies: 15
    Last Post: 01-03-2012, 02:39 PM
  5. Match Index from Data sheet to Individual Sheet
    By dawnmau in forum Excel General
    Replies: 5
    Last Post: 06-21-2010, 02:47 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