How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
Tags:
Answers
-
Try this...
=INDEX(COLLECT({Column To Pull From}, {Name Column}, @cell = [Attribute Name]@row, {Version Number Column}, @cell = [Version Number]@row), 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!