Index match with Left

BlueQuestion
BlueQuestion ✭✭
edited 01/16/25 in Formulas and Functions

I'm trying to make an Index/Match formula and I can use some help.

I have a Smartsheet with a list of parts (Sheet1). I also have a Smartsheet that has a list of part prefixes and a contact for parts beginning with that prefix (Sheet2).

I would like to do an Index match on my parts smarsheet (sheet1) so that any parts beginning with the letters/numbers referenced on sheet 2 return the contact from sheet 2. I don't want to use CONTAINS, since I only want the prefix of one sheet to match

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!