Multiple lookups query



I've a sheet with various user names and 5 columns and trying to get the lookup to report on a user name and count up total of same instance in each of the columns -this can be 0-5 per row. In essence below is what I am trying to get to:

If user name = "Joe Bloggs" and column 1 = "abc" OR column 2="abc" OR column 3="abc" OR column 4="abc" OR column 5-"abc" this gives a result.

Any assistance much appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!