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!
Sign up to be notified when next post is available.
Leave A Response
You must be logged in to post a comment.