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:
which almost works.=INDEX(PAYEES!$A$1:$AQ$1,SUMPRODUCT((PAYEES!$A$2:$AQ$200=E74)*COLUMN(PAYEES!$A$2:$AQ$200)))
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.
Bookmarks