I want my cell B2 to display an integer depending on what the cell next to it (A2) displays. Catch is, I have a table to help reduce the amount of IFs I program. I put the table on another sheet for space and cleanliness
As I change A2, I want B2 to display what that table says the value should be. For example: If A2 is 15, I want it to display in B2 what the table references 15 equals, which would be 2. When A2 changes to 16, I want B2 to reference the table again, which it would then display 3.
Example Table
-----------
| 14 | 2 |
-----------
| 15 | 2 |
-----------
| 16 | 3 |
-----------
| 17 | 3 |
-----------
| 18 | 4 |
Is this possible? Is there a more efficient way to do this? Or is it a lost cause?
Bookmarks