4 Replies Latest reply: Oct 27, 2010 8:16 AM by KOENIG Yvan
FoxtrotFred Level 1 Level 1 (0 points)
When using VLOOKUP in Excel, I could reference a range in a different Excel file. Can't seem to do that in Numbers. Is it possible?

iMac, Mac OS X (10.6.4), iWork '09
  • Jerrold Green1 Level 7 Level 7 (29,855 points)
    Fred,

    No, Numbers can't do external doc references.

    Consider sending Feedback to Apple via the Numbers Menu. Let them know that this capability is important to you.

    Jerry
  • FoxtrotFred Level 1 Level 1 (0 points)
    Thanks Jerry. I was afraid this would be the answer. I believe I have a work-around for now, and I've submitted the following request to Apple at your suggestion:

    I recently purchased a 27" iMac and am in the process of migrating as much of my workflow to Mac OS as possible. For the rest, I'm using VMWare Fusion with a Windows 7 VM. In my opinion this combination makes an ideal platform to do just about anything.

    However, in my business of designing and manufacturing electronic products, I need to manage inventory of a large number of items used to build the circuit boards I design. I have a master parts database and many bills of material - all in Excel spreadsheets. I use the VLOOKUP function extensively to coordinate data between the BOM's and the master parts list. The requires the lookup columns range to be in an external file.

    Unfortunately, I apparently cannot reference an external file from the VLOOKUP function in Numbers '09 as I can in Microsoft Excel. BUMMER!!! I would really like to migrate this process to MAC OS, but now I'm stuck.

    BOTTOM LINE: In the next version of iWork, please include the ability to reference external files from within functions such as VLOOKUP.
  • Badunit Level 6 Level 6 (11,380 points)
    Apple has had a lot of time to work on the next version of iWork. I am waiting anxiously to see what they deliver.
  • Level 8 Level 8 (41,780 points)
    FoxtrotFred wrote:
    BOTTOM LINE: In the next version of iWork, please include the ability to reference external files from within functions such as VLOOKUP.


    Here, you aren't "speaking" to Apple representatives but to end users like you.

    If you really want to "speak" to Apple, use the dedicated channel :

    _Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
    Then, cross your fingers, and wait _at least_ for iWork'11

    Yvan KOENIG (VALLAURIS, France) mercredi 27 octobre 2010 17:16:51