A semi-exoctic formula from Peo S a few years ago, this looks up across
eight sheets. It is an array-entered formula... CTRL+SHIFT+ENTER

If you wnt to tackle this I will help you, I don't completely understand the
formula but I believe I can guide you through it to lookup over many
worksheets. (formula is all one one line in both cases, wrap kinda sucks
here on my screen)

=VLOOKUP(A1,INDIRECT("'"&INDEX({"Sheet1";"Sheet2"; "Sheet3";"Sheet4";"Sheet5";"Sheet6";"Sheet7";"Shee t8"},MATCH(1,--(COUNTIF(INDIRECT("'"&{"Sheet1";"Sheet2";"Sheet3"; "Sheet4";"Sheet5";"Sheet6";"Sheet7";"Sheet8"}&"'!A 2:A200"),A1)0),0))&"'!A2:C200"),2,0)

Or using a named range of the sheets instead of each sheet name...

=VLOOKUP(A1,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A1)0) ,0))&"'!A2:C200"),3,0)

HTH
Regards,
Howard

"cp402" wrote in message
...
I am trying to use the VLOOKUP function over multiple worksheets, can this
be
done on Excel 2003?

I am trying to automatically retrieve data that is dependent on previously
entered fields in drop down lists that I have created.

Regards,