+ Reply to Thread
Results 1 to 2 of 2

Links or HLOOKUP

  1. #1
    Chi
    Guest

    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. #2
    Forum Contributor
    Join Date
    11-29-2005
    Posts
    142
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1