Hello,
If you are able to help, I would be greatly appreciative!
I would like to find a formula that would look up the value in a cell, find the matching columnvalue and return the value on the the corresponding row of the value looked up.
For example...I would like to look up Schusser's class year in the matching column and return the value 10, which is in the Schusser's row.
you should try this formula :
=vlookup("Schusser",your table,2)
I don't have the English version of Excel installed on my computer, so I don't remember if the symbol used is "," or ";" like in the French version.
I let you replace your table by the correct table which contains the 6 lines and the 6 rows apparently.
the number "2" is to get the value of the second row of your table (for year 2012 apparently).
