+ Reply to Thread
Results 1 to 6 of 6

INDEX MATCH - INDIRECT cell reference.

  1. #1
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    279

    INDEX MATCH - INDIRECT cell reference.

    Hi guys, anyway someone would be able to change this to INDIRECT which references the worksheet to target in a 'Register'!$K$23?

    Please Login or Register  to view this content.
    So where it says 'Chiller PM' instead of it being that. instead being referenced to K23 on sheet 'Register'. (Which will be the sheet to target in K23)

    similar to this other one im using in a way.
    Please Login or Register  to view this content.
    Thanks
    Last edited by LeeBillington; 07-18-2018 at 02:13 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: INDEX MATCH - INDIRECT cell reference.

    Presumably

    =(IFERROR(INDEX(Indirect("'"&K23&"'!"K23)&......blah blah

  3. #3
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    279

    Re: INDEX MATCH - INDIRECT cell reference.

    I tried doing it myself and couldn't do it.. kept messing it up somehow. hence why i asked if someone could? sorry if i didn't explain that.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: INDEX MATCH - INDIRECT cell reference.

    Try

    =(IFERROR(INDEX(INDIRECT("'"&Register!$K$23&"'!$G$1:$XFD$1"),SMALL(IF(INDEX(INDIRECT("'"&Register!$K$23&"'!$G$31:$XFD$1900"),MATCH('Holiday - Registers'!$C$3,INDIRECT("'"&Register!$K$23&"'!$C$31:$C$1900"),0),)>0,COLUMN($G:$XFD)-6),ROWS($1:2))),""))

  5. #5
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2016
    Posts
    279

    Re: INDEX MATCH - INDIRECT cell reference.

    Worked Perfectly, thanks jonmo1

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: INDEX MATCH - INDIRECT cell reference.

    You're welcome.

+ 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. Replies: 7
    Last Post: 01-10-2017, 11:11 PM
  2. [SOLVED] Max and reference cell. Use Vlookup or Index/Match?
    By bortolosso in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2016, 09:10 AM
  3. [SOLVED] Using INDEX, MATCH, and INDIRECT to reference cells in other sheets
    By jgilbe31 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-14-2015, 02:02 PM
  4. Replies: 5
    Last Post: 01-30-2015, 06:39 PM
  5. Replies: 4
    Last Post: 01-13-2014, 04:16 AM
  6. #Value error when using INDEX and MATCH to reference a cell
    By willow77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-01-2013, 08:56 AM
  7. Using INDEX MATCH to reference a cell that has a CONCATENATE
    By myshadeofglory in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2011, 01:40 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