Return to Question

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob
4      | Mike

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

I am enclosing a [spreadsheet for testing purposes][1]:

• Data Validation sheet, holds lookup values
• Generic sheets is where the data validations should occur. Column A (hidden) should hold numeric IDs, depending on the value selected from the lookup table, while column B should hold the selected name....

Should handle duplicates in column B (names) [1]: https://docs.google.com/spreadsheets/d/1fLCq_zbsS5DSn6cihsfo3z-ywBiEzgb7PSZnwj7UtHE/edit#gid=0

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob
4      | Mike

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

I am enclosing a spreadsheet for testing purposes:

• Data Validation sheet, holds lookup values
• Generic sheets is where the data validations should occur. Column A (hidden) should hold numeric IDs, depending on the value selected from the lookup table, while column B should hold the selected name....

Should handle duplicates in column B (names)

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

I am enclosing a spreadsheet for testing purposes:

• Data Validation sheet, holds lookup values
• Generic sheets is where the data validations should occur. Column A (hidden) should hold numeric IDs, depending on the value selected from the lookup table, while column B should hold the selected name....

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob
4      | Mike

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

I am enclosing a [spreadsheet for testing purposes][1]:

• Data Validation sheet, holds lookup values
• Generic sheets is where the data validations should occur. Column A (hidden) should hold numeric IDs, depending on the value selected from the lookup table, while column B should hold the selected name....

Should handle duplicates in column B (names) [1]: https://docs.google.com/spreadsheets/d/1fLCq_zbsS5DSn6cihsfo3z-ywBiEzgb7PSZnwj7UtHE/edit#gid=0

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

Let's say we have a Google Sheet used as a data validation "table"

********************************
ID     | Name
********************************
1      | Mike
2      | Sue
3      | Bob

Is there a way to use this table as a data validation aid in other sheets so that the data validation dropdown will show the names, while actually storing the ID?

I am enclosing a spreadsheet for testing purposes:

• Data Validation sheet, holds lookup values
• Generic sheets is where the data validations should occur. Column A (hidden) should hold numeric IDs, depending on the value selected from the lookup table, while column B should hold the selected name....