If I have a Data Grid (called: Jan ) that has 3 columns ( $, #, %), and 2 Rows (Account #, Sales Rep,) what formula would I use in a separate Data Grid (called: Data) to pull specific columns.

Example: I want to populate the "$" value listed in "Jan" if the Row is "Account #1"

Hoping there is a formula where I can basically ask: "return the $ value from Jan if Account # is equal to 1"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!