Understanding the OFFSET and MATCH Combination This lets you lookup a value in any column and return a value from any column. Unlike the VLOOKUP function which can only lookup in the first column. The MATCH function can be used to find the position of a value in a singe row or column range.