Forum Discussion
Index Match combined with Right where Data in cell contains Alpha not numeric
Hello. I have been playing with Index Match to lookup values in multiple spreadsheets - either within a workbook or across workbooks and generally don't have an issue. The situation I have now is w...
It doesn't matter whether or not the lookup column is sorted. I disarranged the data in the lookup column. Nonetheless, LOOKUP returns the expected results, as shown below:
