LOOKUP OR FIND WITH SUMUP COMBINED


Hello,

Hope you could help me.

On Sheet 1, "Future Column", I would like to find in Sheet 2 all similar names against sheet 1.

Ex. In Sheet 1 - BOFA, BOFACBRE, BOFAJLL is on Sheet 2 all in Different rows. I would like to combine and sum up as for Sheet 1 "Future" is equal to 9.


SHEET 1


SHEET 2


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!