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