Numeric value:

For Sheet1,...,Sheet4

=SumProduct(Sumif(INDIRECT("Sheet"&Row(1:4)&"!A2:A 6"),$A
$2,INDIRECT("Sheet"&Row(1:4)&"!B2:B6")))

http://boisgontierjacques.free.fr/fi...rcheV3DNum.xls

AlphaNumeric value:

=VlookUp(A2,INDIRECT("Sheet"&Match(True,
(CountIf(INDIRECT("Sheet"&Row(1:4)&"!A2:B6"),A2)0 ),0)&"!A2:B6"),
2,False)
valid with Shift+Ctrl+Enter

http://boisgontierjacques.free.fr/fi...heV3DAlpha.xls

http://boisgontierjacques.free.fr/pa...3D.htm#Rechv3D

JB
http://boisgontierjacques.free.fr/

On 11 mar, 01:33, cp402 wrote:
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,