Sunday, July 18, 2021

Use Wildcards to Lookup and Sum Up Values

Have you ever received a list and wanted to do a lookup to add some values up, but the looked up value was combined with other text? Sure you could try to pull out that looked up value into another column and then use it to help with the lookup process to perform the calculation, but that would be more steps. You could actually use a wildcard to help out in this situation to match the looked up values and then perform your sums. Click on the video to see what I'm talking about.

No comments:

Post a Comment