INDEX/MATCH - I want to return a blank cell if another cell is also blank

Sarah_lee123 ✭✭
edited 07/18/22 in Formulas and Functions

Hello, thanks in advance for the help.

I am using a DISTINCT formula.

Then I have an INDEX/MATCH formula in the next cell, pulling in from a different sheet. I have the IFERROR part programmed, but I would also like it to give a blank cell result if there is not a number in the "Harvest Batch Name" column. This way, If I haven't yet assigned a name, it won't pull in anything for the "Immature plant batch UID". Is there another part of the function that will allow me to tell it to leave it blank if the other cell is also blank?

Thanks so much!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!