I'm not sure I understand what you mean by

"The data is found on another table within the workbook. "

Are you saying that you are looking up the values, such as 30% and
50%, from the other tables, depending upon what the year is?