Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 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,470
    Thanks
    30
    Thanked 62 Times in 58 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 17:37.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 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
  •