+ Reply to Thread
Results 1 to 3 of 3

Using a Sheet in Your Function, but sheet name as cell value and not just the sheets name

  1. #1
    Registered User
    Join Date
    01-14-2017
    Location
    US
    MS-Off Ver
    2010
    Posts
    6

    Using a Sheet in Your Function, but sheet name as cell value and not just the sheets name

    If my title wasn't confusing enough, I'm trying to make it so I can reference a sheet using a value of the cell within my formula.


    My formula (in C12)
    =VLOOKUP(H14,B15:D17,HLOOKUP(H15,C13:D14,2,FALSE))

    How could I make this formula specific to sheet?

    I would like to make it so the name of the sheet referenced is that value of cell C9.

    Any suggestions?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Using a Sheet in Your Function, but sheet name as cell value and not just the sheets n

    Like this:

    =INDEX(INDIRECT("'"&C9&"'!$B$4:$C$6"),MATCH(C11,INDIRECT("'"&C9&"'!$A$4:$A$6"),0),MATCH(C10,INDIRECT("'"&C9&"'!$B$2:$C$2"),0))

    BUT you need to remove the first line of the PACLAB sheet so that the array is in the same place on every sheet.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Using a Sheet in Your Function, but sheet name as cell value and not just the sheets n

    In "PACLAB" sheet remove first line & modify your formula as :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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] VBA - Create New Sheets Based on Index Sheet Cell Values with Link to Index Sheet
    By order in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-02-2017, 06:23 PM
  2. Replies: 0
    Last Post: 09-16-2015, 01:18 PM
  3. [SOLVED] Create Sheets and copy rows to the Sheets if cell contains sheet names
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 08:06 AM
  4. Function to copy cell contents from sheet 1 to sheet 2
    By cameron213 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2014, 08:13 PM
  5. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  6. If match between two sheets, copy adjacent cell from sheet 2 to sheet 1?
    By VBnoob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2011, 04:02 AM
  7. Replies: 4
    Last Post: 03-22-2011, 09:44 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