+ Reply to Thread
Results 1 to 5 of 5

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

  1. 11-17-2013, 04:05 AM #1
    Jokeman
    Jokeman is offline
    Registered User
    Join Date
    04-21-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

    Hi All

    Im trying to using the table below to lookup the score and score% according to the month.
    Like, if I type "'080111" in A13"Ben" in cell B13,
    Jan-13 to Mar-13 and D16 to D18 will show the particular score according to the month in the table.

    Does anyone know which type of formula should I use.
    I was trying to use IF(AND(Vlookup at the same time, but what comes out is #N/A.

    Thank you all!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-17-2013, 08:02 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "mat

    Hi, and welcome to the forum

    Please see attached file with your solution.
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 11-17-2013, 08:04 AM #3
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "mat

    On sheet2 in cell D16, input the following formula and copy it down.

    Please Login or Register  to view this content.

    Another way to do this by using Index and Match. In cell F16 input the formula given below. This is an array formula so you need to confirm it with Ctrl+Shift+Enter and copy across and down until you get the blank cells.

    Please Login or Register  to view this content.
    See the attachment.
    Attached Files Attached Files
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  4. 11-17-2013, 09:06 AM #4
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,561

    Re: Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "mat

    Or use a pivot table
    Here all 3 on a row
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  5. 11-17-2013, 12:05 PM #5
    Jokeman
    Jokeman is offline
    Registered User
    Join Date
    04-21-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "mat

    Hi All

    Thank you for all your suggestions. Its my fault I forgot to tell if I will continue to add student no., student name, month, score continuously, what should I do, as I tried the above formulas. I think there is another formula can afford not to amend everytime.

    Also, if I use Index, can I included the Title like student no., student name.... like included all row 1.?

    Thank you all!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  2. Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank
    By DanBraden in forum Excel General
    Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  3. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  4. HELP on "left","right","find","len","substitute" functions
    By serene83 in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 09:23 PM
  5. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1