Cross-Sheet Formula Help


I'm trying to create a cross sheet formula that looks at the content of multiple columns in a row on one sheet and looks to another sheet to confirm those values are present, and then returns a value in that sheet.

I've tried VLOOKUP and an IF statement, but I'm not able to get it to work properly. FYI - within each column there may be duplicate values, however, uniqueness can be achieved by combining the information from multiple columns.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!