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

Sarah_lee123 · 07/15/22

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!

Genevieve P. · 07/18/22

Hi @Sarah_lee123

Yes! You can add an IF statement at the very beginning before your formula to first check if the cell is blank:

=IF([HARVEST BATCH NAME]@row = "", "", formula

Let me know if that makes sense or if you'd like to see the full formula spelled out.

Cheers,

Genevieve

Sarah_lee123 · 07/19/22

@Genevieve P. I apologize, but I do need it spelled out for me. I tried to figure it out, but I am still pretty green when it comes to formulas.

Thanks so much.

Genevieve P. · 07/19/22

Hi @Sarah_lee123

No problem at all 🙂

=IF([HARVEST BATCH NAME]@row = "", "", IFERROR(INDEX({IMMATURE BATCH ID}, MATCH([HARVEST BATCH NAME]@row, {HARV BATCH NAME}, 0)), ""))

This way the formula will first look to see if the cell is blank or = "", then if it is, it will return a blank cell, "", otherwise if that cell is not blank, it will then go through your Index(Match formula.

Let me know if this now works for you!

Genevieve