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:
Post Comments (Atom)
Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.
ReplyDelete