Good Online Courses for complex Excel functions

Don't know about on-line courses, but I've found these videos (and the associated web site) quite useful. Have a look at

https://www.youtube.com/results?search_query=%23MsExcel

Tim

Try this...
INDEX returns a value at the intersect (meeting) of a row and a column.
INDEX() syntax is =INDEX(range,row-num,column-num)
so something like =INDEX(A1:J10,3,5)
will return the contents of E3 (row 3, column 5)
Didnt even use MATCH, did we?

Now, to find the "3" or the "5", we would use the MATCH function...
MATCH syntax is...=match(criteria-to-find,column-to-search-in,0) 0 returns exact match
=MATCH("cc",A1:A10,0) (note this is searching down col A)
If "cc" is in A3, this will return 3
(to find the column number, we use the same thing, just change the range=MATCH(criteria-to-find,row-to-search-in,0)
=MATCH("zz",A1:J1,0) (note this is searching across row 1)
If "zz" is in E1, then this will return 5

Put them all together and you have...
=INDEX(A1:J10,MATCH("cc",A1:A10,0),MATCH("zz",A1:J10))

Happy to help