I have the main sheet that I'm working on. The median income table for 2007
is on a separate sheet named 2007. Likewise for 2006-2000.

"Mike Anas" wrote:

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?