I have associated several names with a group number in one spreadsheet (i.e.
one column has the name, the next column has the group number). I want to
move those names to a different spreadsheet and associate those names to a
specific column. Formula might be something like "if group number equals "1"
in spreadsheet X, list it in column Y in spreadsheet Z. Can anyone help?

Sally