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
Check out the Formula Handbook template!