I have a spreadsheet where I have around 90 selections to choose from depending on what number is selected in the cell. I have one tab labeled "Ministers" where i keep the data. Here is a quick example of what it looks like.
Column A Column B
1 John Doe
2 Jane Doe
3 Suzie Doe
All the way up to 90 or so, all with different names.
My other tab is labeled Schedule which has columns were these name will be entered.
Instead of typing these names over and over again on the schedule tab, I would like to setup a separate tab (currently it is on the same tab called Schedule to make it easier) where I input a number and the name populates in the cell. For example, if I type the number 1, then it should input John Doe, if I type in number 2, then it would input Jane Doe.
I have this currently setup to work with values up to 9. After I try to enter the 10th one, it gives me a message where the nesting has exceeded its limit for the format type.
On the tab called "Schedule" I have three columns where I need these name to populate and the numbers I am inputting is just out to the right.
Once I get the nesting limit figured out, I will move the numbers to a separate tab.
One other thing to mention. Each cell needs to have the ability to take a name that corresponds with a number of 1-90. I will just copy them out to the other cells.
How can I get around the nesting limit.
Below is what I have working currently up to 9 nestings.
=IF(K3=1,Ministers!$B$1,IF(K3=2,Ministers!$B$2,IF(K3=3,Ministers!$B$3,IF(K3=4,Ministers!$B$4,IF(K3=5,Ministers!$B$5,IF(K3=6,Ministers!$B$6,IF(K3=7,Ministers!$B$7,IF(K3=8,
Column A Column B
1 John Doe
2 Jane Doe
3 Suzie Doe
All the way up to 90 or so, all with different names.
My other tab is labeled Schedule which has columns were these name will be entered.
Instead of typing these names over and over again on the schedule tab, I would like to setup a separate tab (currently it is on the same tab called Schedule to make it easier) where I input a number and the name populates in the cell. For example, if I type the number 1, then it should input John Doe, if I type in number 2, then it would input Jane Doe.
I have this currently setup to work with values up to 9. After I try to enter the 10th one, it gives me a message where the nesting has exceeded its limit for the format type.
On the tab called "Schedule" I have three columns where I need these name to populate and the numbers I am inputting is just out to the right.
Once I get the nesting limit figured out, I will move the numbers to a separate tab.
One other thing to mention. Each cell needs to have the ability to take a name that corresponds with a number of 1-90. I will just copy them out to the other cells.
How can I get around the nesting limit.
Below is what I have working currently up to 9 nestings.
=IF(K3=1,Ministers!$B$1,IF(K3=2,Ministers!$B$2,IF(K3=3,Ministers!$B$3,IF(K3=4,Ministers!$B$4,IF(K3=5,Ministers!$B$5,IF(K3=6,Ministers!$B$6,IF(K3=7,Ministers!$B$7,IF(K3=8,