How do you SKIP a BLANK cell when using an INDEX / MATCH formula?

Options

This is a working formula to pull values from another sheet. The issue is that on the SOURCE sheet, when the "PCN" is blank, they are showing a default text under the "Enrollment - PCN" column. That works perfectly for the SOURCE sheet, but is messing the automations on MY (destination) sheet.


=IFERROR(INDEX({Projected Enrollment}, MATCH([PCN]@row, {Enrollment - PCN}, 0)), "")


How do I modify the above working formula to skip the INDEX/MATCH is the "PCN" column in MY sheet is blank?

I have tried the following two formula variations, but they do not work :(


=IFERROR(IF([PCN]@row <> "", (INDEX({Projected Enrollment}, MATCH([PCN]@row, {Enrollment - PCN}, 0)), "")


and


=IFERROR(IF(ISBLANK([PCN]@row, "", (INDEX({Projected Enrollment}, MATCH([PCN]@row, {Enrollment - PCN}, 0)), "")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!