Replace values in column if not in a named range

[JackDanIce]

Hi,

I wish to transform a column where if a value is not found on a named Excel range, with a default value, how can I do this as an applied step?

My formula to replace blanks is:

= Table.ReplaceValue(#"Changed Type1","","Missing",Replacer.ReplaceValue,{"Make"})

I would like to add the equivalent of:
If each value in "Make" is not in <list> then replace with "Missing"

I'm not sure of the syntax or how to define the list tbl_Make (found on Sheet: "Reference Tables", address range: J4:J8, header: J3)

TIA,
Jack