Bringing in different groups of numbers dependant on the value in another cell..

[jimbob007]

Hi,

I am trying to tell a spreadsheet to bring in a different group of values dependant on what is written in another cell. Essentially, I am trying to tell the spreadsheet to do the following: if A1="hellohello", bring in one group of numbers, if A1="goodbyegoodbye" bring in another group of numbers, if A1= "Welcomewelcome", bring in another group of numbers and so on.

I have tried using a series of IF statements, but they just seem to bring back the number at the top of each range rather than the whole range. I want the applicable range of values to be displayed in a drop down box in my desired cell, not just one single number.

Is using an IF statement appropriate?

 

[BrianMH]

Do these lists change or is it a fixed list of values for each A1 value?

 

[jimbob007]

They are a fixed set of numbers for each one. So, for the first A1 value, the group of numbers are 0,1,2,3, for the next A1 value, the group of numbers are 4,5,6,7 and so on.

 

[BrianMH]

Check this link out.

Use validation to create dependent lists - Excel