Power Query - Check value for Error?

[gazpage]

Hi,

I have two columns of data, one of which is the primary source but contains some #N/A's. For those rows I want to take the data from the secondary source.

I know how to create a conditional column and can use the wizard to check for certain values, or even nulls, but I don't know how to check for an Error. Typing a value of "Error", or Error, does not work.

Kind regards,
Gary

 

[SyedUsman]

You could replace the error with something like "000001" & then apply the Condition.

 

[gazpage]

Thanks, that worked.