The Value MATCH

MATCHing a value in a list is particularly useful for automating look-ups to other data where the columns and rows aren’t consistent from month to month.  An example of this is reports earlier in the year, where empty accounts or business units are excluded.  Later, once they have data in them, they appear on the report and mess up your column and row counts, unless you’ve already planned for that!  Check out this video to learn the first step in doing so.

Thanks for stopping by!

Previous tip

Sign up to be notified when next post is available.


Leave A Response

* Denotes Required Field