Hot Tip: INDEX/MATCH Formula "Shortcut"

Cleversheet ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Copy/paste this to quickly build these formulas:

=IFERROR(INDEX(ReferenceSheetPickContentColumn, MATCH([CurrentSheetMatchColumn]@row, ReferenceSheetPickMatchColumn, 0)), "")

Then just double-click the concatenated-word segments, replace the outer ones using the ReferenceAnotherSheet link from the Formula Help panel that automatically appears [except when looking within a sheet*], and the inner one by just typing the column name.

In the reference sheets I replace "Range 1..." with "Pick[NameOfContent/MatchColumn]" and tap the applicable column heading.

* -  People usually think of using INDEX/MATCH between sheets, but there are slick occasions to use it within sheets, too.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!