Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: Lookup in sheet from another file sheet

    Hi: Can any one please tell me how to i create a lookup sheet. I mean every time when i open the excel file it automatically update the data into the sheet from another excel file.

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. It works best to have both workbooks open when setting this up. Depending on which form of lookup you use (LOOKUP, VLOOKUP, or INDEX/MATCH), the form will vary but the reference is still valid. Here is one example using INDEX/MATCH:

    =INDEX([Data.xls]!$A2:$K$100,MATCH($A18,[Data.xls]!$A$2:$A$100,0),E$14)

    Note, that the workbook reference is in square brackets.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jul 2006
    Posts
    157
    ok thanks only last thing which is my target workbook and which one is source

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Data in the example above is the source.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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