Thanks Max for the follow up..

--Just to add on if 'Sep 09' is a text string entered in cell Z1 try the
formula Max offered. If you want an exact match try
=VLOOKUP($A1,INDIRECT("'"&Z1&" Update'!A:B"),2,0)

--Incase that is a date formatted to view as Sep 09 then you

=VLOOKUP($A1,INDIRECT(TEXT(Z1,"""'""mmm yy"" Update'!A:B""")),2,0)


If this post helps click Yes
---------------
Jacob Skaria

"Max" wrote:

=VLOOKUP($A1,INDIRECT(Z1&" Update!A:B"),2)

I'd always include the possibility of target sheetnames having spaces.
Try it like this, with apostrophes:
=VLOOKUP($A1,INDIRECT("'"&Z1&" Update'!A:B"),2)
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---