Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,559
    Thanks
    139
    Thanked 12 Times in 12 Posts

    Using indirect formula within Vlookup

    I have a workbook where I use a vlookup which looks up a value in another workbook

    I want to use an indirect formula so that I can change the year when the file name year changes from say Brtbsept20014 to BR1Tbsept2015


    See attached sample files


    Your assistance in resolving this is most appreciated
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,579
    Thanks
    44
    Thanked 76 Times in 71 Posts
    HowardC, try this:

    =VLOOKUP(A5,INDIRECT("[Br1Tbsept" & $C$1 &".xls]Sheet1!$A$1:$D$100"),4,FALSE)
    Last edited by kweaver; 2015-04-11 at 16:37.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,559
    Thanks
    139
    Thanked 12 Times in 12 Posts
    Hi Kweaver

    Thanks for the help, much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •