Excel Magic Trick 1094

Wildcards for Sheet References and INDIRECT function

TOPICS IN THIS VIDEO

  • See how to lookup all A8 cell references from across many sheets using a wildcards, incomplete sheet names and the INDIRECT function.