View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Vito
 
Posts: n/a
Default Links or HLOOKUP


in A4 of your Student workbook enter,

=[CLASS.xls]Sheet1!A4, replacing Sheet1 with the actual sheet name, if
different.

Then copy this across to N4 and then down to N14.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493895