Same Formula returning a blank cell

Hi, I am working on updating an error message to return "No Resource Assigned" however the same formula is now returning a blank cell. Both columns have the same properties (contact list), and this same IFERROR(VLOOKUP) formula has worked on multiple rows prior to this blank cell and continues for the rest of the columns I am trying to fix.

=IFERROR(VLOOKUP(Brand@row, {Client Assignments for Affordability Progr

Range 1}, 10, false), "No Resource Assigned")

=IFERROR(VLOOKUP(Brand@row, {Client Assignments for Affordability Progr

Range 3}, 7, false), "No Resource Assigned")

Any help is greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!