http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-match/
In case the link breaks, here is the formula breakdown (screenshots from above site):
Thursday, October 29, 2015
Excel and Google Sheets
I found this article and learned that I can use index and match in place of vlookup. Now my grade book can look up any data from any assessment and list out a score.
http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-match/
In case the link breaks, here is the formula breakdown (screenshots from above site):
http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-match/
In case the link breaks, here is the formula breakdown (screenshots from above site):
Subscribe to:
Posts (Atom)