Here's one try ..

Assume you have

In Sheet2, in A1:C1
----------------------
Dept20 4500 9000

In sheet: Dept20
---------------------
(Workbook is assumed saved)

Put in any starting cell, say in C4:
=VLOOKUP(MID(CELL("filename"),FIND("]",CELL("filename"))+1,32),Sheet2!$A:$C,
COLUMN(B1),0)

Copy C4 across to D4

C4 and D4 will return 4500 and 9000

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Ernst" wrote in message
...
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