Hot Tip: INDEX/MATCH Formula "Shortcut"

Cleversheet

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.

Andrée Starå

Hi,

Great tip!

Thanks for sharing!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD