I'm struggling to figure out how to get sheets to first look up the location of a key value and then look up which of the sub values it should take. Best would be to include an example, which:
https://docs.google.com/spreadsheets/d/1pL62W7pSImMlTdnU3RMV4VDK3KIuNBT8l3VxClLGTd4/edit?usp=sharing
What I'm hoping to achieve is that the values for item 1, when selected, auto fill in the correct gear builder fields.
Any advice on this is hugely appreciated.
Aucun commentaire:
Enregistrer un commentaire