Match Collect Formula?


I have one sheet that has a list of Account Numbers and Account Names. This list is managed by one Department who adds to it as needed.

I have a second sheet, managed by another Department who uses the Account Numbers and manually enters them. They don't enter the Account Names. They haven't been needed and could be mispelled if manually entered.

We now need to add the Account Names to the second sheet. I would like the names to auto-fill from the other sheet but have not figured out a formula to look it up and pull it in without being an exact row match.

Any ideas?

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!