+ Reply to Thread
Results 1 to 2 of 2

Need cell to find data and extract from one sheet of 10 possible sheets

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    New Hampshire
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need cell to find data and extract from one sheet of 10 possible sheets

    TestSheet.xlsx


    In the "database" sheet, there'll be two cells. One "ext[ension]" and the other "hall". I need the extension cell to reference the other sheets with regards to the data in the "hall" cell. So if the individual is in G103, I need the formula to extract that information from the proper sheet.

    In every instance the data being extracted is exactly 1 cell away from the "hall" information cell, if that makes sense, as you can see in the testsheet attached.

    As always I appreciate the help I get here. You guys rock.
    Last edited by JimmyHuss; 07-12-2012 at 03:39 PM. Reason: solved

  2. #2
    Forum Contributor
    Join Date
    10-08-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    386

    Re: Need cell to find data and extract from one sheet of 10 possible sheets

    Is there any reason you need all the data in 10 different sheets, and organized the way it is? if you are trying to return the extension based on the persons name or the hall, then it would be much easier to put all the halls and relative extensions in a single sheet with and 2 columns. the vlookup function is perfect for what you want.

+ 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