Using a drop-down to populate the next 10 columns with pre-set values

[MrAVR2]

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?

 

[bs0d]

Why not just use an formula with an if condition, combined with VLOOKUP? First, on another tab create a table that correlates the TX PLATFORM with Language. I'd list Languages on rows and then two columns: One for "Encompass + Italy", another for "Iberia". Next to each language, key in the correct code based on the TX PLATFORM.

Once you have that created, here is a formula you could use. Assume your "TX PLATFORM"cell is "A2". Then in "B3" you could use the formula:

=IF($A3="Encompass + Italy", VLOOKUP(B$2, Sheet2!A:C, 2, FALSE), VLOOKUP(B$2, Sheet2!A:C, 3, FALSE))

Copy that formula to all the cells that should have a conditional value. You may need to revise the formula to match your specific situation. For instance, update "Sheet2" to the location of the table you created. Also, of course it's looking for the table in columns A:C (Where columns are: Language, Encompass Italy, and Lberia). Use the appropriate columns that correspond where you actually created your table.

 

[MrAVR2]

Thankyou! I'm a complete newbie to formulae and VLOOKUP in Excel, so having the example formula to work from is fantastic!