This is a tutorial on LibreOffice covering, LibreOffice Calc. The tutorial explains how to use the Match and Index functions with named ranges. The tutor starts off by demonstrating how to use the match function with named cells and ranges. The tutor goes on to explain how the Index function works. The final part of the video covers how to use the match function with the index function to get the intersection required. This video covers, named cells, named ranges, The Index function, and the Match function. How to create a two way lookup. Lookup in LibreOffice. Calc is part of LibreOffice.