Results 1 to 4 of 4

Lookup Values from three different columns in a table matrix

Threaded View

prkhan56 Lookup Values from three... 12-22-2011, 02:25 PM
JieJenn Re: Lookup Values from three... 12-22-2011, 02:37 PM
Haseeb Avarakkan Re: Lookup Values from three... 12-22-2011, 02:39 PM
prkhan56 Re: Lookup Values from three... 12-23-2011, 03:18 PM
  1. #1
    Forum Contributor
    Join Date
    06-03-2004
    Location
    India
    MS-Off Ver
    2013
    Posts
    205

    Arrow Lookup Values from three different columns in a table matrix

    Hello All
    I am using Excel 2010 and have the problem as shown in the attached file.

    There are 3 Sheets Report, EmpName,Target

    Range Names - EmpName, EmpTable,MonthHeader,YearHeader

    I am trying to look up for Targets for each Year against each Employee Name entered in Cell B2 in the Report Sheet

    I tried the formula which gives the #REF Error

    =VLOOKUP($B$2,EmpTable,INDEX(EmpTable,MATCH(A7,MonthHeader,0),MATCH($D$6,YearHeader,0)))

    Can anyone guide me with this problem?

    Thanks in advance.
    Rashid
    Attached Files Attached Files
    Last edited by prkhan56; 12-23-2011 at 03:24 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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