Is it possible to have a header look at a cell to determine what it should
say? I am currently doing two scenarios in my excel file. When a cell in a
different tab says "1" I want the header to say "10 Year Amortization",
otherwise I want it to say "15 Year Amortization". There will also be text
above the 10 or 15 Year amortization line which is consistent for the two
scenarios. Is this possible? Thanks in advance.

--
Message posted via http://www.officekb.com