I have a list of names. I also have a matrix containing the names and their corresponding auditor as the column heading. I need to lookup the name in this matrix and once the name is found, I need to get the auditor which is the column heading. I have a code that works vertically but i can't find the formula to make it work horizontally.

[![enter image description here](https://i.stack.imgur.com/XLP5Y.png)](https://i.stack.imgur.com/XLP5Y.png)

This is my working code for the vertical matrix:

```
=IFERROR(INDEX(auditors,MATCH(1,MMULT(--(names=A106),TRANSPOSE(COLUMN(names)^0)),0)),"")

```