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!