Hello,



I need to search a table of data (PAYEES!$A$2:$AQ$200) for a Name (contained in E74) and return the column heading (PAYEES!$A$1:$AQ$1).

I have this formula:

=INDEX(PAYEES!$A$1:$AQ$1,SUMPRODUCT((PAYEES!$A$2:$AQ$200=E74)*COLUMN(PAYEES!$A$2:$AQ$200)))
which almost works.

However, this seems to return a value even when there is no match.

How can I adapt this to return an error when the searched for value is not found?



Thanks in advance to anyone that helps with this.