SOLVED

Relations between tables?

%3CLINGO-SUB%20id%3D%22lingo-sub-3240355%22%20slang%3D%22en-US%22%3ERelations%20between%20tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240355%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20sheets%20containing%20two%20tables%2C%20see%20screenshots%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Sheet%201%3A%20''Tables''%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352329iCFC5328A3999CBCF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22PAtesting_0-1646215527397.png%22%20alt%3D%22Sheet%201%3A%20''Tables''%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESheet%201%3A%20''Tables''%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sheet%202%3A%20''Overiew''%22%20style%3D%22width%3A%20318px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352330iE61C6FA5F11EB1F7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PAtesting_1-1646215631962.png%22%20alt%3D%22Sheet%202%3A%20''Overiew''%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESheet%202%3A%20''Overiew''%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20that%20I%20want%20to%20automatically%20fill%20%3CSTRONG%3Ecolumn%20A%3C%2FSTRONG%3E%26nbsp%3B(Table)%20in%20S%3CEM%3Eheet%202%2C%3C%2FEM%3E%20with%20the%20name%20of%20the%20table%20(found%20in%26nbsp%3B%3CEM%3ESheet%201)%20%3C%2FEM%3Ethat%20contains%20this%20information.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EKyle%20-%20South%20Africa%20-%20Cape%20Town%3C%2FU%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20should%20fill%20the%20cells%20in%20%3CSTRONG%3EColumn%20A%3C%2FSTRONG%3E%20with%26nbsp%3B%20''Table%203''%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3ELars%20-%20Sweden%20-%20Jokkmokk%3C%2FU%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bshould%20fill%20the%20cell%20in%20%3CSTRONG%3EColumn%20A%3C%2FSTRONG%3E%20with%20''Table%202''%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20so%20forth....%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20find%20''relationships''%20under%20data%2C%20maybe%20because%20I%20am%20using%20Excel%20Drive%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3240355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3240594%22%20slang%3D%22en-US%22%3ERe%3A%20Relations%20between%20tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240594%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1313580%22%20target%3D%22_blank%22%3E%40PAtesting%3C%2FA%3E%26nbsp%3BDidn't%20you%20ask%20the%20same%20question%20here%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fenter-table-name-in-cell%2Fm-p%2F3220155%23M136362%22%20target%3D%22_self%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fenter-table-name-in-cell%2Fm-p%2F3220155%23M136362%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20difference%20is%20that%20you%20now%20provide%20a%20more%20specific%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3240652%22%20slang%3D%22en-US%22%3ERe%3A%20Relations%20between%20tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3240652%22%20slang%3D%22en-US%22%3EIt's%20still%20unclear%20to%20me.%20I%20thought%20my%20question%20was%20not%20clear%20enough%20that's%20why%20I%20provided%20a%20clearer%20example.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi there,

 

I have two sheets containing two tables, see screenshots below:

 

Sheet 1: ''Tables''Sheet 1: ''Tables''

 

 

Sheet 2: ''Overiew''Sheet 2: ''Overiew''

 

My issue is that I want to automatically fill column A (Table) in Sheet 2, with the name of the table (found in Sheet 1) that contains this information. 

 

Kyle - South Africa - Cape Town        should fill the cells in Column A with  ''Table 3'' 

Lars - Sweden - Jokkmokk                 should fill the cell in Column A with ''Table 2'' 

 

and so forth.... 

 

I can't find ''relationships'' under data, maybe because I am using Excel Drive?

 

3 Replies

@PAtesting Didn't you ask the same question here?

https://techcommunity.microsoft.com/t5/excel/enter-table-name-in-cell/m-p/3220155#M136362 

The only difference is that you now provide a more specific example.

It's still unclear to me. I thought my question was not clear enough that's why I provided a clearer example.
best response confirmed by PAtesting (Occasional Contributor)
Solution

@PAtesting Just wondering why you accepted something as a solution when it was not. Did you look at the Power Query option I gave you? You don't need the table names in each of the three tables and PQ can pick them up for you. And if you don't want to use PQ, perhaps the attached file will get you started. It uses INDEX and MATCH, though it's not very elegant.