+ Reply to Thread
Results 1 to 3 of 3

Pull data from different columns based on info in column "A".

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    38

    Pull data from different columns based on info in column "A".

    Hello!

    I'm having a little trouble figuring out what formula to use for situation. I have 5 columns of information.

    Column A = School # of current school
    Column B = School 1 Name
    Column C = School 2 Name
    Column D = School 3 Name
    Column E = School 4 Name


    What I want to do is in Column F to look through a row of information and find the current school.

    So:
    If A="1", pull from B
    If A="2", pull from C
    If A="3", pull from D
    If A="4", pull from E

    I tried doing a VLOOKUP table, but I think I'd have to do one for every row, but I could be wrong. I also thought of INDEX(MATCH), but I couldn't quite figure it out.

    Any ideas? Thanks!

    - Santana
    Last edited by PowerSchoolDude; 08-25-2009 at 03:25 PM.

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

    Re: Pull data from different columns based on info in column "A".

    Are you looking at data in a Range like B1:E1?

    Then: =Index(B1:E1,A1)
    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
    06-22-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Pull data from different columns based on info in column "A".

    Wow. Looks like I was just over complicating things.

    It works perfect, Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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