look up value in array and return the value from another column on the same
row number where the lookup value is found in the lookup array