Effective in version 10.1.1, you can perform a lookup. Use the lookup function to lookup a key column in another sheet and fetch values in corresponding other columns in that looked up sheet.
For more information, see the "Prepare Data" chapter in the