I have a wookbook with two sheets, named "Dept20" and sheet2. On sheet2 I
have my raw data; Cell A1 "Dept20", Cell B1 4,500.
On sheet Dept20 I want to write a vlookup that can reference the data on
sheet2 by relating to the name of the active worksheet rather than typing
"Dept20" in the vlookup formula.

Any ideas?

Thanks

Ernst