Does anyone know if it is possible to use a formular that would return a
selected range (from a different worksheet), based on the content of a given
cell?

I want to use the first worksheet as a form with the second worksheet
containing dropdrown lists and ranges. The situation I want to create is if
A1=AMH, the B1:B6 would be filled by a named range in the second worksheet.
is this possible?

Alan