Skip to main content
2 of 2
Formatting
Vidar S. Ramdal
  • 17.4k
  • 11
  • 71
  • 82

If you want to avoid a script (which gives you a one-off update when you run it) and use a more dynamic approach (ie update instantly when you change the value of X in a subject tutors list), then the If and Vlookup functions are a good option.

Put your master list into alphabetical order, by the unique value that you want to identify your teachers by.

Then in each teacher-data cell in the teachers sheets say something like

=if (B1 = "X", vlookup (A1, master-list-data-range, 3, 0  ), "")

that's basically saying If X THEN find the value in cell A1 in the first column of master-list-data-range, and then to return the value from the 3rd colum.
ELSE show blank.

MaryC.fromNZ
  • 7.3k
  • 1
  • 20
  • 31