[{"name":"Product Request Sheet (Destination)","previewUrl":"https:\/\/app.smartsheet.com\/b\/publish?EQBCT=00dd60b61f06494d8e8a37beda6a067c","assetId":6723255154986884,"assetType":"SHEET"},{"name":"Product Listing (Source Sheet)","previewUrl":"https:\/\/app.smartsheet.com\/b\/publish?EQBCT=26afa39711cc4a53b32a62791c303f40","assetId":223962466307972,"assetType":"SHEET"},{"name":"Priority Matrix (Source)","previewUrl":"https:\/\/app.smartsheet.com\/b\/publish?EQBCT=5f296cc00cd04b5a90710815aed88fd9","assetId":5654014456713092,"assetType":"SHEET"},{"name":"Prioritization Sheet (Destination)","previewUrl":"https:\/\/app.smartsheet.com\/b\/publish?EQBCT=f4da1c8bad64459db1dce75997298e3c","assetId":4331405047713668,"assetType":"SHEET"}]

Making the most of INDEX/MATCH

Expand your use of INDEX and MATCH!

Use Template

Description

Contains the examples demonstrated in the ENGAGE 2023 breakout session: Making the most of INDEX/MATCH. Includes an example of using MATCH to search in multiple columns for a lookup value, and using INDEX/MATCH/MATCH to replace VLOOKUP and retrieve values from a table

Complexity

Medium

Instructions

Setup information

More Support

Process Map

Template preview

Select items to see live previews of template content.