Rewriting scalar function to table function

I have already written that solution, however I need it to return a null when a match isnt found. ITs tricky to do within a table fucntion but easier with scalar as you can assign within a scalar function.