Hi guys,
I want to create a 2-item drop-down such that when you select each item it will populate the following 11 columns with pre-set values related to that item.
Here's the sheet as it stands, which we've been populating manually by copying and pasting...
I want to make the "TX Platform" column the drop-down, so you have a choice of either "Encompass + Italy" or "Iberia". Whichever you pick, it should populate the following 11 columns with the languages as shown, including the blanks - it's always the same languages for each choice, there's never any variation.
Is this another use of VLOOKUP, or is it different because it's going horizontally?
I want to create a 2-item drop-down such that when you select each item it will populate the following 11 columns with pre-set values related to that item.
Here's the sheet as it stands, which we've been populating manually by copying and pasting...

I want to make the "TX Platform" column the drop-down, so you have a choice of either "Encompass + Italy" or "Iberia". Whichever you pick, it should populate the following 11 columns with the languages as shown, including the blanks - it's always the same languages for each choice, there's never any variation.
Is this another use of VLOOKUP, or is it different because it's going horizontally?