Skip navigation

Getting data from an other spreadsheet

307 Views 9 Replies Latest reply: Nov 30, 2012 6:48 AM by Wayne Contello RSS
Roland nl Calculating status...
Currently Being Moderated
Nov 30, 2012 12:31 AM

Hello, ( dutch i will try my best englisch   )

 

I have two spreadsheats.

 

1 Klanten bestand ( customers file )

1 Factuur  ( invoice )

 

When i put in the invoice the cusomer number i want to get out of cusomors file the adres.

 

I can do that whitin 1 spreadscheet but i need to do that whitin the two.

 

Now i have

 

=ZOEKEN(H10;Klantenbestand::Tabel 1 :: $A;Bedrijfsnaam) 

 

     could be in english 

               = LOOKUP (H10; client file :: Table 1 :: $ A; Company Name)

 

I think it should be somthing like

 

=ZOEKEN(H10; file location :: Klantenbestand::Tabel 1 :: $A;Bedrijfsnaam) 

         

     could be in english

               = LOOKUP (H10; file location :: client file :: Table 1 :: $ A; Company Name)

 

I cant find somting related whit google or in the forum.

 

Is there some one who knows how to ???

 

And i would like to work whit iCloud if posible....

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.