Need Help with Referencing Functions

[Libbia]

Hello, I am creating a template to track bills. Referencing other
templates, I have set up functions that will change the date in my
table according to the week displayed in my combo (drop down) box. I
cannot figure out what function to use (INDEX?) or how to format the
function in order to make my creditors display automatically under the
date the bill is due. So far I have my creditor, due date and amount
due lists in the formula worksheet.

Also, why is the $ used in formulas?
EX: =INDEX(Formulas!B$21:B$26,week)

 

[davesexcel]

I think you may be asking for dependant menus,
here's a link to contextures, maybe it will be what you are looking
for

http://contextures.com/xlDataVal02.html