Hi, I have a set of master data as a named table, for this purpose "MASTER"

I have numerous sub-sets of data, which I want to reference to MASTER for a
certain value. If the key figure is not part of MASTER, the lookup returns
#N/A - I was wondering if there was a way of navigating round this, replacing
with a zero or something?