What can I add to return a blank if the cell referencing is blank?
I have a formula that pulls in some information from another sheet. =INDEX({Function}, MATCH([Support Manager (email)]@row, {Assigned}, 0)). The formula works fine except that I want it to return a blank if the "Support Manager (email)" is blank. Unfortunately the "Assigned" columns in the sheet it is referencing has blanks so my formula grabs the first blank in the reference file and gives me an answer. I want it to show "Support Manager Organization" as blank if the "Support Manager (email) is blank.
Thanks.
Amy
Best Answer
-
Hi @Amy Bedard ,
You could do something like this:
=IF(ISBLANK([support manager (email)]@row),"",
and then insert your INDEX formula.
This translates to "if the support manager email column in this row is blank, show blank. Otherwise, run the INDEX formula.
Hope this helps! Let me know if it works for you.
Best,
Heather
Answers
-
Hi @Amy Bedard ,
You could do something like this:
=IF(ISBLANK([support manager (email)]@row),"",
and then insert your INDEX formula.
This translates to "if the support manager email column in this row is blank, show blank. Otherwise, run the INDEX formula.
Hope this helps! Let me know if it works for you.
Best,
Heather
-
Yes. That worked. Thank you.
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!