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...
Thanks for the reply.
The Lookup functions seems very like VLOOKUP in that it requires the Lookup column to be sorted in Ascending order. Although in the sample data I provided this is the case simply because I put it together quickly, in my live dataset the data is not sorted in Ascending order.
Although I could presumably sort the data, I started using Index match in preference to VLOOKUP because it did not require me to manipulate the raw data and I would like to know if there is a way to get this to work with Index Match.
Regards
Steve O.
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: