Results 1 to 6 of 6

INDEX MATCH - INDIRECT cell reference.

Threaded View

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

    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?

    =(IFERROR(INDEX('Chiller PM'!$G$1:$XFD$1,SMALL(IF(INDEX('Chiller PM'!$G$31:$XFD$1900,MATCH('Holiday - Registers'!$C$3,'Chiller PM'!$C$31:$C$1900,0),)>0,COLUMN('Chiller PM'!$G:$XFD)-6),ROWS($1:2))),""))
    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.
    =IFERROR(VLOOKUP(C4,INDIRECT("'"&Register!$K$23&"'!$C$23:$XFD$1900"),MATCH(D4,INDIRECT("'"&Register!$K$23&"'!$C$1:$XFD$1"),0),0),"")
    Thanks
    Last edited by LeeBillington; 07-18-2018 at 02:13 PM.

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