+ Reply to Thread
Results 1 to 3 of 3

Vlookup Formula Change A Part ("Sheet Name") According to Cell Value

  1. 12-29-2023, 05:54 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Post Vlookup Formula Change A Part ("Sheet Name") According to Cell Value

    hi,
    i am using a code to apply vlookup formula in range E6

    Please Login or Register  to view this content.
    i want to change sheets name accroding to Range C4 value

    Screenshot_2.jpg

    thanks
    Attached Files Attached Files
    Last edited by HaroonSid; 12-29-2023 at 05:57 AM.
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 12-29-2023, 06:07 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,363

    Re: Vlookup Formula Change A Part ("Sheet Name") According to Cell Value

    Try

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 12-29-2023, 06:39 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Vlookup Formula Change A Part ("Sheet Name") According to Cell Value

    Thanks,its working
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. "Worksheet change" not changing cell on other sheet to match target cell "fill".
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-02-2015, 12:02 PM
  2. "Cannot change part of a merged cell"
    By globulous in forum Excel General
    Replies: 4
    Last Post: 12-29-2014, 03:09 PM
  3. [SOLVED] "You cannot change part of an array" I just want to get the hell out of this cell
    By Dallas Vette in forum Excel General
    Replies: 2
    Last Post: 08-03-2014, 10:49 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] Can I enter a "Y" and return "Yes" in the same cell? PART 2
    By rbbbbeee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2006, 07:25 AM
  6. [SOLVED] "Cannot change part of merged cell"
    By ExcelHelpNeeded in forum Excel General
    Replies: 1
    Last Post: 07-06-2006, 01:33 PM
  7. [SOLVED] "Cannot Change Part of a Merged Cell" When updating link using mac
    By Madhava in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2005, 05:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1