Yes, the INDEX excel function works for both horizontal and vertical data. Hence, this can be used as an alternative to both VLOOKUP and HLOOKUP with the combination of the MATCH function.