Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    London
    Posts
    64

    Unanswered: Referencing External Workbooks

    Good afternoon everyone, i hope you can help.

    I have a workbook that uses vlookups to return values from another file. What i want to be able to do is change that file based upon the selection from a combo box. i know i have done this is thepast but cant for the life of me remember how i did it.

    my current formula is:
    =vlookup(AB2,'C:\TEMP\Chris\[PRV_Car_2009_5+7.xls]Monthly'!$A$7:$N$18,5,0)

    i basically want to be able to change the 5+7 part of the file name somehow so it will look at a different file based upon the selection made.

    Hope that makes sense.

    Thanks

    EddiesVoicebox

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    I think you're looking for the INDIRECT function.

Posting Permissions

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