i have a spreadsheet wherein i need some data to appear from a table.
i tried using vlookup and hlookup but as they only use one criteria, i couldnt achieve my goal.
index_match_1.jpg
in the image you can see the table on the right. this is the data i need to be inputted in to the left-hand side of the spread sheet in column G (under the Points achieved heading)
i've used the INDEX and MATCH functions to try and pick the data on the right-hand-side-table
the criteria is, it needs to lookup the corresponding data for the respective month and student name...
so if the date is set to "Dec-17" in cell A2 and i want the points for "Student2" i need to return "261" as the result.
i have used the following formula but it is returning me with an error:
=INDEX(M8:O12,(MATCH(B8,L8:L12,0)),MATCH(A3,M7:O7,0))
please could someone help me out
thanks
Bookmarks