+ Reply to Thread
Results 1 to 5 of 5

to fetch value from corresponding cell

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    kolkata
    MS-Off Ver
    Excel 2003
    Posts
    6

    to fetch value from corresponding cell

    I have a list of students eg John, Smith, Russel, Rahim, akbar, Sailja in Col. A from A1 to A6. In next column B their total marks from B1 to B6 eg. 348, 457, 389, 490, 391, 375 is present. I want to prepare a mark-sheet in the same work sheet where I can fetch names from data validation list but how the marks will automatically appear in next cell. Suppose I select the name of akbar in d5 how the total marks of akbar 490 shall automatically appear in e5 ?
    I have a total list of more than 200 students and their total marks. Please give me a solution.

    Please also suggest me how to prepare said mark sheet in another work sheet of same file

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: to fetch value from corresponding cell

    Hi and welcome to the forum

    In E5.

    =INDEX(B1:B6,MATCH(D5,A1:A6)
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    06-05-2012
    Location
    kolkata
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: to fetch value from corresponding cell

    thanks for the solution, but it is not working properly, I have tried, it is returning the highest value of the array. please suggest.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: to fetch value from corresponding cell

    Would you like to upload a small sample workbook?

  5. #5
    Registered User
    Join Date
    06-05-2012
    Location
    kolkata
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: to fetch value from corresponding cell

    thanks a lot i have solved it out, if I put =INDEX(B1:B6,MATCH(D5,A1:A6,0)) instead of =INDEX(B1:B6,MATCH(D5,A1:A6) it is returning the actual value.

+ 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