hiya
i have 2 dropdown lists the 2nd list determend by the first (dropdown from a
dropdown) what i would like to do is hyperlink from this second list which is
based on the 1st.

i have at the moment =HYPERLINK("#"&B2&"!A1","GO")

but because b2 depends on a2 its not linking can anyone help please?? i've
tried =HYPERLINK("#"&A2:B2&"!A1","GO") and others but it returns #value.

please help i'm going crazy here lol .................
--
deejay