Does the INDEX / MATCH formula have to match exactly?

Berto D

Berto D ✭✭

08/29/22 edited 08/29/22 in Formulas and Functions

Can I use INDEX / MATCH for partial matches?

Tags:

Formulas

0 ·

Answers

Marvin Daniels ✭✭✭✭✭

08/29/22

Hello @Berto D Yes. You will need to add a CONTAINS function and this thread does a great explaining it.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…