What can I add to return a blank if the cell referencing is blank?

Amy Bedard

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

Heather Duff

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

Heather Duff

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

Amy Bedard

Yes. That worked. Thank you.

Heather Duff

Happy to help!