Give VLOOKUP a try. For example. How to use INDEX MATCH to search by row and column values. This formula is an Advantages of INDEX · INDEX & MATCH - formula. Automatic Column Matching. When adding multiple data tables to an analysis, Spotfire will automatically match columns with the same name and data type.