+ Reply to Thread
Results 1 to 2 of 2

Using indirect in a match function to change row dinamically

  1. #1
    Registered User
    Join Date
    01-29-2009
    Location
    madrid, spain
    MS-Off Ver
    Excel 2003
    Posts
    26

    Using indirect in a match function to change row dinamically

    Hi,

    I would be grateful if you could help me with a problem I have when using MATCH.
    How can I reference a row dinamically? I have it currently set on 7:7 but I would like to use a formula (indirect?) so that it changes according to the values of another cell:

    Thanks a lot!
    Laura

    Capture.JPG

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

    Re: Using indirect in a match function to change row dinamically

    Try

    =MATCH(C5,INDEX('v2'!$A:$XFD,ValueOfAnotherCell,0),0)

+ 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. [SOLVED] Need help with indirect/index/match function
    By TreeLife in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2016, 10:44 PM
  2. INDIRECT referencing to the cell that changes dinamically -> REFERENCE ERROR
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2015, 09:52 AM
  3. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  4. Indirect with Match/Index function
    By jyothijayanna in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-18-2013, 09:39 PM
  5. INDIRECT function together with INDEX MATCH
    By coasterman in forum Excel General
    Replies: 3
    Last Post: 12-09-2011, 11:06 AM
  6. MATCH function within INDIRECT function not working
    By mgerada in forum Excel General
    Replies: 2
    Last Post: 09-04-2011, 08:37 AM
  7. dinamically change cell reference
    By gago in forum Excel General
    Replies: 3
    Last Post: 10-21-2009, 05:19 AM

Tags for this Thread

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