Hi.

I am having success using vlookup on a sheet (Week 1).

The vlookup formula is as: =VLOOKUP(B8,'Week 1'!A2:F17,4,FALSE)

It properly returns "Thu" from column 4 of the mentioned array in the
sheet named "Week 1".

B8 sequences up in the array as it is the lookup reference value.

My copied array of that formula also works.

I want to replace 'Week 1' sheet name declaration with a call to a
sheet whose name is stored in a cell like "B2". The cell contents matches
the sheet name exactly And is chosen from a drop down list validation
schema at present.

I have 17 sheets of data, and one sheet to examine them in, and the drop
down list allows choosing a sheet (week), I want that drop down cell
content to be the replacement text in the vlookup formula. That way the
sheet contents reflects the selected week's data.

Also, it would be nice to reference a named array in the "A2:F17" part
of the formula like "Week 1" through "Week 17" in the formula, also based
on the contents selected for B2.

I cannot remember how to declare the string so that excel looks at it
correctly.