+ Reply to Thread
Results 1 to 4 of 4

Pull data from another sheet if specified cells match

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    St Louis MO
    MS-Off Ver
    Excel 2007
    Posts
    7

    Pull data from another sheet if specified cells match

    Hi! I need a formula that will look at the school name in column A and then look at the principal name in column D. The principal on sheet 2 coulumn D is different to return the the name of the new principal. I work with a lot of spreadsheets where the data is all over the place and I am looking for a formula that will allow me to say if row contains a school name on both sheets the pull the data from the specified column to match that school. Sample.xlsx

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Pull data from another sheet if specified cells match

    In E2 try:

    =VLOOKUP(A2,Sheet2!A:D,4,0)

    copied down
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    St Louis MO
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Pull data from another sheet if specified cells match

    Thank You. That looks like it will work. Do you mind explaining where the 4 comes from so that I will know how to apply the formula to other circumstances?

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Pull data from another sheet if specified cells match

    The 4 means get the data from the 4th column in range A:D

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    St Louis MO
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Pull data from another sheet if specified cells match

    That formula worked great for that circumstance. If I have more data and the school names fo not match exactly (sheet one says Adams and sheet 2 says Adams Elementary) do I need to tweak the formula to still get a match?

+ 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