Oeldere, surely that would just bring back the value in column B, i.e. c in Alice's case? If the names are in column A and you want to bring back the cell reference for this name, try =ADDRESS(MATCH("Alice",$A$1:$A$8,0),COLUMN(A1)). If you want to bring back the column entered in column B and the row entered in column C, try =VLOOKUP("Alice",$A$1:$C$8,2,FALSE)&VLOOKUP("Alice",$A$1:$C$8,3,FALSE). If you wanted to bring back the absolute values rather than a cell reference, nest these formulas within indirect: =INDIRECT(ADDRESS(MATCH("Alice",$A$1:$A$8,0),COLUMN(A1))) or INDIRECT(VLOOKUP("Alice",$A$1:$C$8,2,FALSE)&VLOOKUP("Alice",$A$1:$C$8,3,FALSE))