VLOOKUP with multiple criteria help


I have a sheet which has 1 column showing a document name, and another column for document revision number.

I need to make a vlookup which returns the owner of the doc, based on the document name and revision number.

I'm aware that the simplest option is to concatenate the two columns but I'd prefer not to add another column and another formula to an already very large sheet. Is this possible?





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!