it sounds like you want to make your vlookup something lik
=vlookup(what, where,count of data)

where count of data is count(sheet1!b2:iv2) - or whatever row woul
have the # of data points in it

--
duan
-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26586