Using INDEX and MATCH together allows you to perform lookups with more flexibility than VLOOKUP. For example, =INDEX(B1:B10, MATCH("Apple", A1:A10, 0)) finds "Apple" in A1:A10 and returns the corresponding value from B1:B10.