+ Reply to Thread
Results 1 to 2 of 2

Match function referring to a Worksheet name in a different cell.

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Newcastle
    MS-Off Ver
    2010
    Posts
    25

    Match function referring to a Worksheet name in a different cell.

    I am having issues linking it to the worksheet's name in a different cell. I thinks its the Indirect function but I can not get it to work.


    This is what I want to the formula to do, and it currently works.

    =MATCH(A6,'08.08.13'!A:A,0)

    My only issue is I have to to many worksheets to make copying in the name for each Match function Viable.

    The name '08.08.13' is located in cell G3

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Match function referring to a Worksheet name in a different cell.

    Hi,

    =MATCH(A6,INDIRECT("'"&G3&"'!A:A"),0)

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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. Help on Application.worksheet.function.match / evaluate+match
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2012, 04:30 PM
  2. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  3. referring a worksheet
    By tired of finding my data scrambled in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 07:05 AM
  4. referring a worksheet
    By lazmanyak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. SUMIF function referring to values on different Worksheet
    By TeeBee0831 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-03-2005, 06:06 PM

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