SOLVED

Enter Table name in cell?

%3CLINGO-SUB%20id%3D%22lingo-sub-3220109%22%20slang%3D%22en-US%22%3EEnter%20Table%20name%20in%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220109%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20complex%20question%20that%20I%20am%20not%20sure%20is%20able%20to%20be%20solved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20an%20Excel%20file%20with%202%20sheets%2C%20calling%20them%20A%20en%20B%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20sheet%20A%2C%20I%20have%20Table%201%2C%202%20and%203.%20In%20sheet%20B%2C%20I%20have%20Table%204.%20Table%204%20is%20the%20table%20that%20collects%20all%20information%20from%20the%203%20tables%20in%20Sheet%20A%20and%20puts%20them%20together%20in%201%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20whether%20it's%20possible%20to%20display%20the%20table%20name%20in%20a%20specific%20column%20in%20Table%204%2C%20depending%20on%20the%20match%20it%20has%20with%20whatever%20one%20of%20the%20three%20tables%20in%20Sheet%20A.%20So%20for%20example%2C%26nbsp%3B%20if%20a%20row%20in%20Table%204%20correlates%20with%20the%20information%20mentioned%20in%20Table%202%2C%20it%20should%20say%20''Table%202''%20in%20the%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20my%20question%20is%20clear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3220109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220155%22%20slang%3D%22en-US%22%3ERe%3A%20Enter%20Table%20name%20in%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220155%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fcreate-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3220194%22%20slang%3D%22en-US%22%3ERe%3A%20Enter%20Table%20name%20in%20cell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3220194%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%3BThat%20seems%20to%20be%20something%20for%20Power%20Query.%20See%20attached%20file%20for%20a%20simple%20example%20following%20your%20description.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I have a complex question that I am not sure is able to be solved.

 

I am using an Excel file with 2 sheets, calling them A en B here.

 

In sheet A, I have Table 1, 2 and 3. In sheet B, I have Table 4. Table 4 is the table that collects all information from the 3 tables in Sheet A and puts them together in 1 table.

 

I want to know whether it's possible to display the table name in a specific column in Table 4, depending on the match it has with whatever one of the three tables in Sheet A. So for example,  if a row in Table 4 correlates with the information mentioned in Table 2, it should say ''Table 2'' in the cell. 

 

I hope my question is clear.

 

Kind regards,

 

 

 

2 Replies
best response confirmed by PAtesting (Occasional Contributor)

@PAtesting That seems to be something for Power Query. See attached file for a simple example following your description.