j_saints
New Member
- Joined
- Sep 21, 2020
- Messages
- 8
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello,
I was hoping someone could help me fix this combination function below.
I have a company table and I want to lookup their parent company based on their keywords.
I'm trying to return "OTHER ACCOUNTS" if the lookup match is blank/error. For some reason, it's returning to 0.
Any help is much appreciated!
I was hoping someone could help me fix this combination function below.
I have a company table and I want to lookup their parent company based on their keywords.
I'm trying to return "OTHER ACCOUNTS" if the lookup match is blank/error. For some reason, it's returning to 0.
Excel Formula:
=IFERROR(XLOOKUP(TRUE,ISNUMBER(SEARCH('PARENT COMPANY'!$A:$A,'COMPANY TABLE'!B1501)),'PARENT COMPANY'!$C:$C),"OTHER ACCOUNTS")
Any help is much appreciated!