| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Links or HLOOKUP
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| options to update automatic links | Excel Worksheet Functions | |||
| Prompt to update links | Links and Linking in Excel | |||
| Deleting links to other spreadsheets | Excel Worksheet Functions | |||
| Update links prompt not wanted | Excel Discussion (Misc queries) | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
