Results 1 to 3 of 3

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

Threaded View

PowerSchoolDude Pull data from different... 08-25-2009, 03:13 PM
NBVC Re: Pull data from different... 08-25-2009, 03:18 PM
PowerSchoolDude Re: Pull data from different... 08-25-2009, 03:25 PM
  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.

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