Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Using VLOOKUP

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On my active worksheet, I have linked to another worksheet, in another file, and used the VLOOKUP function. But I am finding that I have to have that other file open in order for the VLOOKUP function to work... otherwise my active worksheet will display #VALUE in the cell. Is this normal with EXCEL or have I done something wrong in my formula? The formula is as follows:

    =SUMIF([InvAFH0104Adj0201.xls]Sched51!$D$2:$D$109,VLOOKUP($B126,'G:FH Master PlanFHMP 2002Inventory[Inventory 2002.xls]Translations'!$A$2:$C$190,3),[InvAFH0104Adj0201.xls]Sched51!$R$2:$R$109)

    Any help would be greatly appreciated!

    Thanks! )

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure you update external references on opening the sheet.

    Good luck

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I will try that! Thanks!

    The spreadsheets I am working with are such a mess right now, I can't update any of the links because it will throw the whole workbook off!!

    Again, Thanks for your help!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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