+ Reply to Thread
Results 1 to 3 of 3

Pulling data from a chart?

Hybrid View

  1. #1
    Registered User
    Join Date
    05-23-2012
    Location
    Campbell, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pulling data from a chart?

    I'm sure this question has been asked, but I can't find the answer anywhere.

    I'm trying to create a formula that will auto populate a cell with a specific number if another cell has a certain name. Pretty basic, I think, but I can't for the life of me figure this out:

    This is my data
    Steve 2201
    Paul 2202
    Jim 2203
    David 2204
    Scott 2205
    Tony 2206
    Josh 2207

    So if cell F14 says "Jim", I would like cell J14 to auto populate with 2203. Can someone please help me??

    Thanks bunches!!!!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,421

    Re: Pulling data from a chart?

    Suppose your list of data above is in cells A1 to B7 in the same sheet. Then you can use this formula in cell J14:

    =VLOOKUP(F14,$A$1:$B$7,2,0)

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-23-2012
    Location
    Campbell, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Pulling data from a chart?

    THANK YOU!!

    I knew this was supposed to be simple!!

+ 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