Hi Franz, thanks for the reply.

I'm not sure how one would use indirect here though. I thought
indirect would go to a cell reference, I need a reference to a
worksheet as part of the array reference in a vlookup.

Regards,
Andy


--
andyiain
------------------------------------------------------------------------
andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335
View this thread: http://www.excelforum.com/showthread...hreadid=560170