Feb 28 2022 02:03 AM
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,
Feb 28 2022 02:50 AM
@PAtesting That seems to be something for Power Query. See attached file for a simple example following your description.