How to get one cell to follow another in a table?

Question

Hi. I have a spreadsheet I use for scheduling people that draws names from a table in one tab (Contacts) and populates name, phone #, etc in Week tabs; what I'd like to do is make it so that if a name moves in the Contacts table, the corresponding row in the Week table follows, is that possible?

Chris is a "yes" for Oct 2. But I need to move them down on the list...

How can I get that "yes" to follow?

Cells C3:I12 are simple text. Columns A and B are linked to the Contacts table in the Contacts tab (as you can see in the formula bar). If I change the position of a name in the Contacts table, how can I get the corresponding row to change on the Week table?

Thanks.

Answer 1

Could you share us a test workbook? Then we may have a try.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

From your description, you should add a help sheet to input the Yes and use formula to match the data to week sheet.

Another way is to use power query self-match.

Answer 2

When you say "help sheet," do you mean like a drop down menu?

Answer 3

Share a test file, then we can make a sample for you.

Answer 4

It's a simple question, why do you need a test file? What do you mean by "help sheet?" I can't find that term anywhere.

Answer 5

For Example,

Column A is a table.

If you want to keep the related comments to it. Create a help sheet to put the comments on it. Column I J

Then when name postion is changed in Table, the related comment will still comes with column D

=VLOOKUP(D2,I:J,2,0)