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.Please Login or Register to view this content.
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