+ Reply to Thread
Results 1 to 4 of 4

Search for a name and return the value of a given cell

  1. #1
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    279

    Search for a name and return the value of a given cell

    Good morning,

    I am trying to search a sheet for a given name and return the total point for that marking period. The main problem i am having is that the names aren't in the same cell on each sheet. It is a list of students and each sheet represents a marking period.

    I have attached the file any and all help would be greatly appreciated.

    Los
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Search for a name and return the value of a given cell

    Like this?
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Search for a name and return the value of a given cell

    Hi,

    Refer attached workbook. Is this what you need?
    Attached Files Attached Files
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  4. #4
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    279

    Re: Search for a name and return the value of a given cell

    Awesome thank you both!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search multiple worksheets for matching cell value and return cell location as a hyperlink
    By wickedsparrow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2013, 08:47 PM
  2. Search column for name and return the value in the cell to the right of it.
    By walker313 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2012, 01:03 PM
  3. Replies: 2
    Last Post: 06-29-2012, 07:02 AM
  4. Replies: 4
    Last Post: 05-12-2011, 02:25 PM
  5. Replies: 1
    Last Post: 01-25-2011, 10:50 PM

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