Index & Match Formula to provide row number if found in column

IB3 ✭✭
edited 06/07/23 in Formulas and Functions

=IF(INDEX(ColumnA:ColumnA,MATCH(ColumnB@row, ColumnB:ColumnB,0), INDEX(Auto:Auto, MATCH(Auto@row,Auto:Auto, 0), "")))

Auto = System column to pull row number

ColumnA =Text

ColumnB =Text

ColumnC= Formula location & Row Number Output

So, what I’m trying to achieve is to have a formula to Lookup ColumnA text and match ColumnB text. If there is not a match, it returns blank, but if there is a match, to return the Auto of ColumnA.


I’m sure I’m overlooking something easy here, as I’m receiving an #INCORRECT ARGUMENT but I would be welcome for your assistance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!