Enter Table name in cell?

[PAtesting]

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 · Accepted solution]

https://support.microsoft.com/en-gb/office/create-a-relationship-between-tables-in-excel-fe1b6be7-1d...

[#3]

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