9 Replies Latest reply: Nov 30, 2012 6:48 AM by Wayne Contello
Roland nl Level 1 Level 1 (0 points)

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....