Links or HLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I entered numbers from A4:N15 in sheet named CLASS. I would like to have
these numbers appear on STUDENT sheet which is in different workbook.

Please show me how.

May I use HLOOKUP function? Or what function I should use?
Thanks
Chi
 
in A4 of your Student workbook enter,

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

Then copy this across to N4 and then down to N14
 
Back
Top