I have a table where one column has numbers from 1 to 25 and another has values corresponding to those numbers.
What I am trying to do is make it so when I change the number in one cell another cell changes to the corresponding number based on the table.
Do I have to do this manually or is there a way to set a range for the cases and values?
Edit: The Sheet.
My awful attempts at this just to explain what I am trying to do are in cells B8 and B9