INDEX and MATCH to complete a Two Column Look-up


I have used excel to complete two column look-ups before using this formula:


J5=column 1 item to match

D5=column 2 item to match

E32:E41= column 1 array to look-up

B32:B41=column 2 array to look-up

However, Smartsheet does not seem to recognize the "&" ampersand function in the formula.

What is a workaround for this missing feature?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!