# Relation between sheets **URL:** \ **Category:** Ask for Help\ **Created:** [September 16, 2019, 7:21pm UTC](https://community.glideapps.com/t/relation-between-sheets/317 "2019-09-16T19:21:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Olivier\_Gibier](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivier_gibier/32/197_2.png) [@Olivier\_Gibier](https://community.glideapps.com/u/Olivier_Gibier)\ **Post date:** [September 16, 2019, 7:21pm UTC](https://community.glideapps.com/t/relation-between-sheets/317/1 "2019-09-16T19:21:16Z")
Hello, Here is my test app : https://test-og.glideapp.io I have a relation field in sheet “Sujets” ![29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/823073e2b3e3d585ce186074478afa842a3b4ac9.png) Is it possible to add just one or many fields of “Membres” sheet in this screen : ![57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/2a014935ce08b1abf884ff682dc3bec042c3d72b.png) For example, i’d like to add the phone number of the member. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 16, 2019, 7:41pm UTC](https://community.glideapps.com/t/relation-between-sheets/317/2 "2019-09-16T19:41:04Z")
Hello! We call this a ‘lookup’ and will add it as a kind of computed column in a few weeks. ---
**Author:** ![Olivier\_Gibier](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/olivier_gibier/32/197_2.png) [@Olivier\_Gibier](https://community.glideapps.com/u/Olivier_Gibier)\ **Post date:** [September 16, 2019, 7:44pm UTC](https://community.glideapps.com/t/relation-between-sheets/317/3 "2019-09-16T19:44:37Z")
Good news, i wait for. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [September 16, 2019, 10:39pm UTC](https://community.glideapps.com/t/relation-between-sheets/317/4 "2019-09-16T22:39:52Z")
This will be very helpful in normalizing the data in the spreadsheets. Sounds great! ---
**Author:** ![cparker](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@cparker](https://community.glideapps.com/u/cparker)\ **Post date:** [September 18, 2019, 1:19am UTC](https://community.glideapps.com/t/relation-between-sheets/317/5 "2019-09-18T01:19:30Z")
Hi Olivier Is this what you mean? ![og_test_tel](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/9ec6f30a4fb576915cde0e02e1e0257268fda955.jpeg) If so, here is an option until the new feature is avail. You can use a vlookup in your excel file, in the ‘Sujets’ worksheet. I’m posting another reply separately with another screenshot (at present I’m only allowed one image per post). You’ll need to add two columns, Membres\_Nom and Membres\_Tel. The vlookup formula to use in the Membres\_Tel column is as follows: =VLOOKUP(D2;Membres!$A$2:$E;3;False) …more to come ---
**Author:** ![cparker](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@cparker](https://community.glideapps.com/u/cparker)\ **Post date:** [September 18, 2019, 1:21am UTC](https://community.glideapps.com/t/relation-between-sheets/317/6 "2019-09-18T01:21:35Z")
Part 2: In Sujets, you’ll need to add two columns, Membres\_Nom and Membres\_Tel. The vlookup formula to use in the Membres\_Tel column is as follows: =VLOOKUP(D2;Membres!$A$2:$E;3;False) Screenshot here: ![sujets_test](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/b2c4ad0e9afd9820d0132f4c10e5fe7f426cd6bb.jpeg) Additional info on VLOOKUP here: [https://support.google.com/docs/answer/3093318?hl=en](https://support.google.com/docs/answer/3093318?hl=en) The reason for adding the Membres\_Nom column in addition to the Membres\_Tel column is because of how VLOOKUP works… Per GoogleSheets documentation: “The first column in the range is searched for the key specified in `search_key` .” Per Excel documentation: “Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.” Nom is the first column in the search range from the Membres worksheet …if ‘Nom\_Prenom’ were the first column, you could use that. Good luck!