VLOOKUP("mike",Sheet1!$A$1:$J$1000,2,FALSE)
insert a column, B, number it 1-??, count the space over to the column
you want it to pick up the info. if cell B13 has the number 3 in it,
it will pick up that information in col. 3,
so change the 2 in the formula to B?.
VLOOKUP("mike",Sheet1!$A$1:$J$1000,B3,FALSE)
copy and paste accross the page


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=516261