+ Reply to Thread
Results 1 to 2 of 2

Change File Name in Formula based on Vlookup

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    23

    Change File Name in Formula based on Vlookup

    Hi,

    My main data set has data with country names in column A. I also have separate files for each country.


    I can make a separate vlookup table where based on the country names where I have copied the file names which ends in -USA.sxlsx or -UK.xlsx or -RU.xlsx and everything else is same.

    How can I have the vlookup or anything else change it based on my main data set containing the country codes?

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Change File Name in Formula based on Vlookup

    Can you, please, write the text of the formula you are using now? I think you can use Indirect function or maybe a macro but without a sample workbook, is hard to say
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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. Dynamic file name change within a Formula based on a Cell contents name.
    By super5200 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 03-20-2021, 01:32 PM
  2. Vlookup with file name change daily
    By Sbrmmd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2018, 02:16 PM
  3. [SOLVED] VBA code for change vlookup formula to vlookup formula with ISNA
    By erprasannaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2013, 03:33 AM
  4. Replies: 4
    Last Post: 12-17-2012, 03:01 PM
  5. Change timestamp based on results of vlookup?
    By infopro247 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-20-2012, 08:50 AM
  6. External File(s) referenced and file links change based on row cell.
    By Jimmydageek in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-23-2009, 02:59 PM
  7. Change formula based on results of vlookup
    By [email protected] in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2008, 04:19 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