jeudi 31 octobre 2019

Vlookup then return a different row in Google Sheets

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