INDEX and MATCH to complete a Two Column Look-up

Options

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

=INDEX(P32:P41,MATCH(J5&D5,E32:E41&B32:B41,0))

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?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!