is it the vlookups that arent working?

probably cos you need to quote the search criteria.

vlookup("H6",Range,returncol,false)


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563633