I have a spreadsheet with two worksheets. The first worksheet (Source Data) contains a Table with 3 columns:
I'd like to show two first columns from that table on the second worksheet (Emails) so I use a formula to reference a particular column of the source Table:
And it would be nice if it is a table as well so I can sort/filter the data.
However, it leads to weird issues. For example, if I resort the data on the Source Data worksheet, insert a new row in between, or delete a row from the middle (shown on the screenshot below), the second worksheet breaks, and the value of the third column ([email protected]
) appears for the wrong record (Kate Ostin
):
Converting the second table (Emails) to a range doesn't help.
What are the possible solutions? Basically, I need to establish a strong relationship between the first two columns containing references (First Name, Last Name) and all other columns (Email) on the second worksheet. Please help on how it can be achieved. Thanks.