Formula to replicate column values when certain value is matched


My source sheet has 3 columns such has Name, Location ID and Grade. When i provide the Location ID in the target sheet, i would require the Name and Grade values to be populated for that respective Location ID.

-For ex: If Location ID 123 is entered in Target sheet only once, then all the Names and Grade which has same location ID, respective names and grade should be displayed.

And also, when the location ID is changed to another value then the name and grade values to be changed and displayed accordingly.

Source Sheet:

Target Sheet: Location ID value is entered only one time; i need all values as below:

And also, if location ID is changed, then values should change accordingly:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!