Dynamic Range based on cell reference?

[fretcruiser]

I want to do an index match, with the ARRAY being dependent on what the user selects from my dropdown box in cell B3. Depending on what they select (it will be days of the week, i.e. Saturday, Monday, etc.), I want the named range reference to change (i.e. if they select Saturday, I want it to reference the Saturday table, located on the "Sat" tab)

How can I get the table name within my index formula to change based on the value of another cell?

 

[JoeMo]

If you have a sheet named "Sat", and B3 on the active sheet has Saturday in it, this will return the value in cell A1 on the sheet "Sat".

=INDIRECT(LEFT(B3,3)&"!A1")

you can adapt this to your index-match formula.

 

[fretcruiser]

You're the best. Thanks.

 

[JoeMo]

You're the best. Thanks.

You are welcome - thanks for the reply.