Results 1 to 3 of 3

Reading from other files

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2011
    Location
    Loxton, Australia
    MS-Off Ver
    Excel 2016
    Posts
    32

    Reading from other files

    With the help from others I am able to now read from a cell on another worksheet using the below formula:
    =VLOOKUP($B$3,INDIRECT("'"&$B$2-1&"'!$A$6:$E$11"),5)

    If i wanted this to read from another file named after cell B2 what would it look like.

    The formula is in the Student Results worksheet on the attached file.

    Paul
    Attached Files Attached Files

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