Searching a column in another sheet

Michael A.
edited 12/09/19 in Formulas and Functions



I'm trying to reference contact info from one sheet and have it show up in another as I type.  I want the second sheet to search a column as I type and match the contact name if it exists.  Does smartsheet have a vlookup or something that can search another column in real-time as I type.  

An alternative would be a drop down list in sheet 2 that has all the contact names from sheet 1.


Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!