Maybe something like this:
starting with the second lookup (4th column)
=IF(OFFSET(Sheet1!$A1,0,COLUMN()/4)="","",OFFSET(Sheet1!$A1,0,COLUMN()/4))
copy paste in every 4th column


HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=497596