Benches Uncategorized

4

VLookup using another file

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Hi, I want to get data from another numbers file using VLOOKUP function. I am familiar with making it from EXCEL but somehow I have problems doing it Numbers '09. Can anyone advise why I cannot fill the argument panel completely.

This is the fileds I have to fill but the columns range is not applicable is using another file. =VLOOKUP(search-for;columns-range;return-column;close-match)

Any advise?

Thanks: Szimi

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You cannot link to another file, that is why you cannot get this to work.

  2. 0

    Szimi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    That is bad 🙂 Thanks for your help.

    Szimi

  3. 0

    themunx

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I'm desperate to do this too.

    We have a table on our Server which has all our customer codes and their latest contact details.

    When we used a windows server and all had Excel, all our other spreadsheets used to look to this using =vlookup and got the latest details.

    Since the move to macs, and iWork, this doesn't work anymore.

    The only work around I have (without paying for Microsoft Office) is to use OpenOffice. Calc seems to be able to use the same vlookup formula to point to a table outside of the current worksheet. It's just a pain to have to use OpenOffice for this one feature because Numbers is much better at nearly everything else!

    Any other ideas anyone?

  4. 0

    Szimi

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I actually succeed to get the data from the given column but I had to copy the workbook from Excel into the Numbers worksheet. Of course a powerful Mac is needed for this 😉

    Since I moved the worksheet I could use the formula as I always did in Excel. It is working well and I love my sheet much better in Numbers than in Excel.

    Do you have any problems with the formula itself?

    Szimi