Referencing another sheet for selective information

David Tompkins
David Tompkins ✭✭✭
edited 12/09/19 in Formulas and Functions

Any help with this would be appreciated.

I haven't been able to come up with a formula that would check a reference sheet for a value and pull the data from another column to populate the current form. I expect it would be a compound formula with an IF and maybe a INDEX,  but I'm having difficulty narrowing it down. - Any thoughts would be much appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!