Hi,

Although it's not explicitly mentioned, when the help says it looks in a contiguous array, my understanding is that a contiguous array means a single row or column of cells. Try using two Index statements concatenated, with the second match element in each wrapped in an IFERROR() statement. to trap a not found item.