Note, this expression could significantly impact sync time

[John_Paul_Armis]

Hi everyone may i ask if there’s alternative way to avoid blank data when using LOOKUP and SELECT

I’m with my Form.
With the Field - Province am using formula as Locations[PROVINCE] the locations is from another table.

With the Field - TD Name am using formula as LOOKUP([Province and MunicipalityCity], “Retail directory”, “Province and City”, “TD”) -

When Field Province is blank or no data my TD Name field also dont have data.

What will be the alternative way to avoid the error as: Note, this expression could significantly impact sync time?